Thomas,

> > Forgive my ignorance regarding how ibo / delphi datasets work, but if
> > it's a 'before insert' trigger, if I do an query.insert in delphi and
> > then a query.cancel, I presume the trigger won't have fired?
>
> A trigger will fire when you commit the transaction in which the DML
> statement was executed. No COMMIT = the trigger won't fire.

This isn't true.

Only EVENTs will be delivered depending on a COMMIT.

Any DML actions in triggers will be executed and, if the transaction
will be rolled back, rolled back as well.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com