Hallo,
we are using MariaDB with Unidac Components 6.4.14 with Delphi 10 Seattle. The database option Autocommit is set to off. Now I want to set the Auticommit to ON for my Application. So I set the Option Autocommit in the UniConnection to true. But if I try to update a table the changes don't take place. I thought this option overides the autocommit setting for this Connection?
How it is possible to set the autocommit for a defined Connection.
Autocommit in UniConnection
Re: Autocommit in UniConnection
When working with MariaDB (MySQL) server the TUniConnection.AutoCommit property is not used. To solve the issue you can execute the following code:
Code: Select all
UniConnection.ExecSQL('SET autocommit = 1');