i use the code:
CREATE TRIGGER "_AU1" FOR TEST
ACTIVE AFTER UPDATE POSITION 0
AS
begin

/* Trigger text */

insert into log values ('1',(select MON$SQL_TEXT
from



MON$STATEMENTS
WHERE mon$state =
1));
end
to caputer updates on table
but i can get the queries with parameters .... i can not see the values in the query
how can i solve this problem ... .


-------- Оригинално писмо --------
От: Thomas Steinmaurer
Относно: Re: [firebird-support] how can i get the sql code of the current
executed statement
До: firebird-support@yahoogroups.com
Изпратено на: Неделя, 2010, Ноември 21 21:18:56 EET

> I want to get the code of the sql statement that fires trigger ...
> if i have after insert trigger when an insert statements is executed i want to get the sql code of that insert into the trigger ...

I think, the insert statement isn't directly linked to the trigger
firing on that in the trace, except for the trigger, also the table name
is part of the trace output and an identical transaction id might also
be somekind of key that they are linked "together".

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/



[Non-text portions of this message have been removed]