AutoCommit and trigger

funky_disco_freak · Post by **funky_disco_freak** » Tue 22 Feb 2005 07:49

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!

Alex · Post by **Alex** » Tue 22 Feb 2005 13:50

You can use AutoCommit option in such situation, commit will be called after triggers.

funky_disco_freak · Post by **funky_disco_freak** » Tue 22 Feb 2005 20:26

Ok...when should I turnb off AutoCommit...in what case...please some example?

THX!

funky_disco_freak · Post by **funky_disco_freak** » Wed 23 Feb 2005 07:38

forget about that....stupid thinking!