> Thanks for the replies... should I take that in an after insert trigger,
> can you not change the values of the inserted record?

For the table the trigger is based on? Yes.

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


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