add new trigger-level variable (for example, :TABLE) to be passed as argument into common SP from several triggers --------------------------------------------------------------------------------------------------------------------
Key: CORE-3663 URL: http://tracker.firebirdsql.org/browse/CORE-3663 Project: Firebird Core Issue Type: New Feature Reporter: Pavel Zotov If we have several tables and many field of them are the same (e.g. same name, type, size) then it is often need to perform similar actions with such fields. In case of handling inside triggers we have repeated code so we should place such code in separate SP. But this SP do not know the name of table for which it is called and the parameter like 'a_table' should be passed from each trigger that calls this SP. I think it will be useful to introduce new "context variable' for triggers a'la :NEW and :OLD, but it must store the name of :TABLE for that trigger is fired. So we do not need to hard code literal name of this table when call SP with common code. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel