I run a transaction that performs an update on a specific table. What I am really doing is adding credits to a user balance. In the database this table has an AU (After Update) trigger that should take the updated balance and update a corresponding record in another table.

For some reason the first table is getting update just fine from my code. However the trigger does not seem to be kicking in and updating the second table.

Is there something else special I have to do from my code to ensure that any associated triggers are invoked as is appropriate?

I always thought that triggers are stupid and just react to events and that that do not care if an Insert/Update/Delete takes place directly in the database or through code. (A Delphi application in this case using IB Objects)

Eric Tishler
Software Architect
Resolute Partners, LLC
Phone: 203.271.1122
Fax: 203.271.1460
etishler@...



[Non-text portions of this message have been removed]