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
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
Hi,you can do this by:Select * from mon$attachments a where
a.mon$attachment_id=CURRENT_CONNECTIONRegards,Karol Bieniaszewski
null
or transactions..
Von: firebird-support@yahoogroups.com
Gesendet: Dienstag, 12. März 2019 11:26
An: firebird-support@yahoogroups.com
Betreff: Re[2]: [firebird-support] Link system tables to trigger
Olaf
If you use same firebird user for all application users, I assume that you have
some
Olaf
If you use same firebird user for all application users, I assume that
you have some list of users within your database.
Then you can set a variable for connection named i.e. my_current_user,
fill it from the application and then use it in i.e triggers in the same
manner that you would