when using transactions

jkuiper · Post by **jkuiper** » Fri 04 Sep 2009 13:00

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?

Dimon · Post by **Dimon** » Mon 07 Sep 2009 06:25

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.