| Subject | I can't use new.FIELD in a EXECUTE STATEMENT called into a Trigger |
|---|---|
| Author | marc_guillot |
| Post date | 2009-07-10T19:45:15Z |
Hello.
In a very simple sample, into a Trigger I can use :
select new.ROW_ID from rdb$database into :ROW_ID
But using EXECUTE STATEMENT this doesn't works :
SQL = 'select new.ROW_ID from rdb$database';
execute statement :SQL into :ROW_ID;
¿ There is any way to access to new. and old. trigger fields into an EXECUTE STATEMENT call ?
I'm writing some logging triggers that will look at all the fields of the table (using the system tables) and logging new values of which have changed.
Thank you.
In a very simple sample, into a Trigger I can use :
select new.ROW_ID from rdb$database into :ROW_ID
But using EXECUTE STATEMENT this doesn't works :
SQL = 'select new.ROW_ID from rdb$database';
execute statement :SQL into :ROW_ID;
¿ There is any way to access to new. and old. trigger fields into an EXECUTE STATEMENT call ?
I'm writing some logging triggers that will look at all the fields of the table (using the system tables) and logging new values of which have changed.
Thank you.