Page 1 of 1

when using transactions

Posted: Fri 04 Sep 2009 13:00
by jkuiper
Now I'm a newbie to transactions, so my question.
If MyDAC is connecting to a INNODB database, is MyDAC using transactions directly or do I have to set it on?
Must de select also in a transaction?

Posted: Mon 07 Sep 2009 06:25
by Dimon
If you don't use transactions obviously by calling the StartTransaction method, then implicit transaction is used and data are commited automatically. That is if you change data (e.g., insert, update, delete), it is saved in a database automaticly on calling the Post method, unless you use transactions. But if you execute the StartTransaction method, then to save data to a database, execute the Commit method.