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 'DISCONNECT_USER'; > It is fired > > 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 > > And when I back to 1 when it worked it is not fired at all
Did you commit the transaction executing POST_EVENT in all scenarios? Events are delivered to the listening client upon transaction commit. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
