Martijn,

>>>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.

Oh, yeah. I stand corrected. Thanks chief. ;-)



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com