|
Home > Archive > SQL Anywhere database > October 2005 > Schedule name within an event
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]
| Author |
Schedule name within an event
|
|
| Roger Holmes 2005-10-27, 7:41 am |
| Is it possible to pick up the Schedule Name from within an event?
I'm trying to do something like:
create event Ev1
schedule Sch1 start time '02:00am' every 24 hours on ('Mon', 'Wed')
schedule Sch2 start time '04:00am' every 24 hours on ('Tue', 'Thu')
handler
begin
case <schedule name>
when 'Sch1' then ....
when 'Sch2' then ....
end case ;
end;
I'm using ASA 7.0.4.3541. Cheers.
| |
| Bruce Hay 2005-10-27, 7:41 am |
| event_parameter('Sch
eduleName') will return that information in later
versions, but is not available in 7.0.4.
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Roger Holmes" <a@a.com> wrote in message news:435fb20d@forums
-1-dub...
> Is it possible to pick up the Schedule Name from within an event?
> I'm trying to do something like:
>
> create event Ev1
> schedule Sch1 start time '02:00am' every 24 hours on ('Mon', 'Wed')
> schedule Sch2 start time '04:00am' every 24 hours on ('Tue', 'Thu')
> handler
> begin
>
> case <schedule name>
> when 'Sch1' then ....
> when 'Sch2' then ....
> end case ;
>
> end;
>
> I'm using ASA 7.0.4.3541. Cheers.
>
>
| |
| Roger Holmes 2005-10-27, 7:41 am |
| Thanks Bruce - just my luck - don't you just find that everything you need
is always available in the next version...
"Bruce Hay" < h_a_y~a_t~i_a_n_y_w_
h_e_r_e~d_o_t~c_o_m> wrote in message
news:435fdc56$2@foru
ms-2-dub...
> event_parameter('Sch
eduleName') will return that information in later
> versions, but is not available in 7.0.4.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
>
> "Roger Holmes" <a@a.com> wrote in message news:435fb20d@forums
-1-dub...
>
>
|
|
|
|
|