Re: [Lazarus] MySQL auto commit

2015-11-11 Thread Aradeonas
mirce.vladimirov point me to commitretaining so I test it ItĀ helps to not getting "Operation can't be performed on active transaction" error but still Im searching for a better way for a auto commit way. Regards, Ara -- http://www.fastmail.com - Faster than the air-speed velocity of an

Re: [Lazarus] MySQL auto commit

2015-11-11 Thread Aradeonas
Thanks to I checked project with trunk version and it works if I set Transaction.Options:=[stoUseImplicit]; But there is a problem it just work with MySQLConnection and not with TSQLConnector even if you set ConnectorType to MySQL. So it seems TSQLConnector have a bug.can any one test it confirm

[Lazarus] MySQL auto commit

2015-11-11 Thread Aradeonas
[Cross posted on forum so if you want answer there : http://forum.lazarus.freepascal.org/index.php/topic,30343.0.html[http://forum.lazarus.freepascal.org/index.php/topic,30097.0.html]] Is there any support for automatically commit changes for MySQL? I test it and it seems there isnt any and I