Page 1 of 1

AutoCommit and trigger

Posted: Tue 22 Feb 2005 07:49
by funky_disco_freak
If I use TSmartQuery (or any other TQuery like component) AutoCommit option, and some insert fire trigger on table which updates some records in other tables, is that OK (according problems that may occure in that trigger part of work), how should I use that option....

I mean do I have to set AutoCommit to false but in that case when should I know that commit can be done or rollback was forced?

Hope I was clear enough...sorry if that post was allready answered.

THX!
:oops:

Posted: Tue 22 Feb 2005 13:50
by Alex
You can use AutoCommit option in such situation, commit will be called after triggers.

Posted: Tue 22 Feb 2005 20:26
by funky_disco_freak
Ok...when should I turnb off AutoCommit...in what case...please some example?

THX!

Posted: Wed 23 Feb 2005 07:38
by funky_disco_freak
forget about that....stupid thinking!
:idea: