Hi



Create a procedure to insert your log and execute that procedure in each
trigger (execute procedure('tablename') ....)



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of orhanturhan
Sent: Monday, August 24, 2009 12:45
To: firebird-support@yahoogroups.com
Subject: [firebird-support] get table name in trigger





for example

CREATE OR ALTER TRIGGER CUSTOMER_BI FOR CARI
ACTIVE BEFORE INSERT POSITION 0
as
begin
...........
insert into logs
(table_name, event_time)
values
(????????????? ,current);
...........
end;

i want to ????????????=trigger table name

if table name is Customer then ????????????=Customer
else
if table name is Items then ????????????=Items

i hope tell myself.





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