Re: AW: AW: Re[2]: [firebird-support] Link system tables to trigger

2019-03-14 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
I forgot to say that from performance POV you should do this only once in eg connection trigger and set context vars.Use then this vars in triggersRegards,Karol Bieniaszewski null

AW: AW: Re[2]: [firebird-support] Link system tables to trigger

2019-03-13 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello Karol, perfekt, thank you! 😊 Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 12. März 2019 14:43 An: firebird-support@yahoogroups.com Betreff: Re: AW: Re[2]: [firebird-support] Link system tables to trigger Hi, you can do this by: Select * from

Re: AW: Re[2]: [firebird-support] Link system tables to trigger

2019-03-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,you can do this by:Select * from mon$attachments a where a.mon$attachment_id=CURRENT_CONNECTIONRegards,Karol Bieniaszewski null

AW: Re[2]: [firebird-support] Link system tables to trigger

2019-03-12 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, I thought similar, would call a stored procedure in my application and set the current user. But there was a little bit hope, that I can get it by using monitor tables, the attachment-table includes all informations and perhaps there is a reference to the statements or transactio