Thanks for your reply. I haven't tried it as I came across Tomasz's suggestion
first, and that works a treat!
Brilliant! Thanks for your help. I learn something new every day.
Tuesday, October 24, 2017, 1:37:01 AM, j...@acousticdesign.co.uk wrote:
> I have a stored procedure along the lines of
> SELECT ID, Amount1, Amount2 ..
> FROM Table1.
> UNION
> SELECT ID, Amount1, Amount2...
> FROM Table2
> ORDER BY 1
> Is it possible to construct a conditional ORDER
On 23.10.2017 at 14:37, j...@acousticdesign.co.uk [firebird-support] wrote:
> I have a stored procedure along the lines of
> SELECT ID, Amount1, Amount2 ..
> FROM Table1.
> UNION
> SELECT ID, Amount1, Amount2...
> FROM Table2
> ORDER BY 1
> Is it possible to construct a conditional
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
> ?
>
Hello
There is BEFORE_DISCONNECT trigger - try it.
You cannot (as I think) stop disconnection - but you can reconnect in your
application
Tom
10 matches
Mail list logo