Thanks for your help.


Thomas Steinmaurer wrote:

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

--
Peter Lee ptle@...
-----------------------------------------------------------------------
Rising Software Australia Pty. Ltd. http://www.risingsoftware.com/
Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
Ph: +61 3 9481 3320 FAX: +61 3 9481 3380 USA Freecall: 1 888 667 7839