I am sorry and I am confused.
I registered event with 'DISCONNECT_USER' instead of 'DISCONNECT_USER]' I
forgot the bracket and now it works for the 1st scenario and not for the second
because I was wrong with using 'DISCONNECT_USER]'||:USR in the PS and
certaintly doesn't work but It give me
> 2-POST_EVENT 'DISCONNECT_USER]'||:USR; (I splitt the event name using
> "]" in the client in order to retrieve the event name part and the username
> part) It is not fired
What event is your application registered/listening for?
'DISCONNECT_USER]', or 'DISCONNECT_USER]'||:USR?
Sean
Hi,
> Yes in my delphi application I registered the event name
> I tried POST_EVENT in a stored procedure but without DELETE FROM
> MON$ATTACHMENTS statement
> sometimes it is fired sometimes not. I didn't understand why
>
>
> When I write the event name like this :
>
> 1-POST_EVENT
Hello,
Yes in my delphi application I registered the event name
I tried POST_EVENT in a stored procedure but without DELETE FROM
MON$ATTACHMENTS statement
sometimes it is fired sometimes not. I didn't understand why
When I write the event name like this :
1-POST_EVENT
> Hello,
>
> I am deleting user connected with:
> DELETE FROM MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID = :ID_CONNECTION;
>
> I need to use POST_EVENT in order to notify user that he has been disconnected
> but don't found a trigger for MON$ATTACHMENTS to do it. Can you please help
> me
> ?
>
> I am deleting user connected with:
> DELETE FROM MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID =
> :ID_CONNECTION;
> I need to use POST_EVENT in order to notify user that he has been
> disconnected but don't found a trigger for MON$ATTACHMENTS to do it. Can
> you please help me ?
AFAIK, it is not
