I don't get it.
A trigger can only be applied to one and only one table, so you, as a
developer HAS to know, which table has this trigger, so you can write in as
a constant literal, like

> insert into logs
> (table_name, event_time)
> values
> ('CARI' ,current);

SanTa

----- Original Message -----
From: "orhanturhan" <oturhan@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, August 24, 2009 11:44 AM
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.
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>