Subject | Re: Firebird 1.5 Alpha1 |
---|---|
Author | Andrew |
Post date | 2002-10-01T19:31:06Z |
* Universal triggers (SF #451922).
Allow one trigger to be fired for a number of action types.
Example:
CREATE TRIGGER my_trigger FOR my_table BEFORE INSERT OR UPDATE
AS BEGIN
IF (NEW.DOC_ID IS NULL) THEN
EXCEPTION my_exception;
END
Contributor(s):
Dmitry Yemanov <yemanov@...>
-----
Wooohooo! Smell that, MSSQL? That's your one advantage going up in
smoke. [Sorry... not competing, not competing... awareness only...]
My DDL scripts just shrunk by a third. Thanks!
Regards,
Andrew Ferguson
Allow one trigger to be fired for a number of action types.
Example:
CREATE TRIGGER my_trigger FOR my_table BEFORE INSERT OR UPDATE
AS BEGIN
IF (NEW.DOC_ID IS NULL) THEN
EXCEPTION my_exception;
END
Contributor(s):
Dmitry Yemanov <yemanov@...>
-----
Wooohooo! Smell that, MSSQL? That's your one advantage going up in
smoke. [Sorry... not competing, not competing... awareness only...]
My DDL scripts just shrunk by a third. Thanks!
Regards,
Andrew Ferguson