At 12:20 AM 12/9/2002 -0300, IBUNC wrote:

>We are investigating on execution order of the triggers, referential
>integrity actions and constraints in face of a statement posted to the
>server.

User "before action" triggers are executed in the order specified.
If the before action triggers insert, update, or delete data, the
before action triggers, constraints, and after action triggers for
those changes are executed as the changes are made. Constraints
are executed next in an arbitrary order. Finally, the after action
triggers are executed in the order specified.

>SQL99 spec says that exec order must be

We do not follow the SQL99 spec and are unlikely to do so. The
spec attempts to define a constant state within an action and
eliminates many actions that Firebird allows.


Regards,

Ann
www.ibphoenix.com
We have answers.