Subject Re: [firebird-support] POST_EVENT and it params
Author Helen Borrie
At 02:12 AM 2/07/2003 +0000, you wrote:
>hi
>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

POST_EVENT actually returns one argument, with three alternative
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