|
Home > Archive > SQL Anywhere Mobile > April 2006 > Event existence
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Douglas 2006-04-07, 8:26 pm |
| What is the command to check for the existence of an event in an ASA 9.0.2
database?
| |
| Greg Fenton 2006-04-07, 8:26 pm |
| Douglas wrote:
> What is the command to check for the existence of an event in an ASA 9.0.2
> database?
IF EXISTS (SELECT 1
FROM sysevent
WHERE event_name = 'your_event')
THEN
MESSAGE 'event your_event exists!!' TO CLIENT;
END IF;
....unless you mean something else by "event".
BTW: this question would be better asked in the sqlanywhere.general
newsgroup (unless you mean something else by "event").
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Breck Carter [Team iAnywhere] 2006-04-07, 8:26 pm |
| On 7 Apr 2006 13:43:05 -0800, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:
>Douglas wrote:
>
> IF EXISTS (SELECT 1
> FROM sysevent
> WHERE event_name = 'your_event')
> THEN
> MESSAGE 'event your_event exists!!' TO CLIENT;
> END IF;
>
>...unless you mean something else by "event".
>
>BTW: this question would be better asked in the sqlanywhere.general
>newsgroup (unless you mean something else by "event").
>
>greg.fenton
....hmmm, he *might* mean "MobiLink event script", this being the
MobiLink newsgroup :)
Breck
--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
breck.carter@risingroad.com
| |
| Greg Fenton 2006-04-07, 8:26 pm |
| Breck Carter [Team iAnywhere] wrote:
> ....hmmm, he *might* mean "MobiLink event script", this being the
> MobiLink newsgroup :)
>
Thus the reason I asked for a description of what "event" meant. If
Breck is right, then we'd need to know which event(s) you are referring
to as the answer will be different for connection scripts vs. table scripts.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|