Subject | Re: [firebird-support] POST_EVENT and it params |
---|---|
Author | Helen Borrie |
Post date | 2003-07-02T04:36:04Z |
At 02:12 AM 2/07/2003 +0000, you wrote:
usages. For the first, you can pass an event name (such as
'Account_added'). Alternatively, you can pass either the current value of
a column, or a string variable that you previously declared in your procedure.
So you have these alternatives:
POST_EVENT 'AccountAdded' ;
or
POST_EVENT NEW."AccID" ;
(Note: double quotes used only if you defined "AccID" in the database
using double quotes)
or
declare variable StringVar varchar(40);
...
StringVar = 'New account added: ' || cast (new."AccID" as char(10)) ;
POST_EVENT StringVar;
heLen
>hiPOST_EVENT actually returns one argument, with three alternative
>i noties two params for POST_EVENT
>what for the second param,cab i use as
>
>POST_EVENT 'AccountAdded' , "AccID"
>
>useing firebird 1.5rc3 delphi ibx
usages. For the first, you can pass an event name (such as
'Account_added'). Alternatively, you can pass either the current value of
a column, or a string variable that you previously declared in your procedure.
So you have these alternatives:
POST_EVENT 'AccountAdded' ;
or
POST_EVENT NEW."AccID" ;
(Note: double quotes used only if you defined "AccID" in the database
using double quotes)
or
declare variable StringVar varchar(40);
...
StringVar = 'New account added: ' || cast (new."AccID" as char(10)) ;
POST_EVENT StringVar;
heLen