How to disable Autocommit in Firedac

Question

How would it be to disable Autocommit type:

FDTable1.AutoCommit := False;

or

FDconection.AutoCommit := False;

I don’t think so.

Answer 1

I think it’s worth noting that the option AutoCommit simply clears the Updatstatus of the records. Other than ApplyUpdates of ClientDataSet, that returned all records to usUnModified automatically, the FDQuery keeps them. I imagine it’s so that we can, after giving a ApplyUpdates, make new changes to the database according to the status of the record.

So if you run ApplyUpdates in a row (due to some automation, for example), you may get a primary key error among others due to the attempt to run the same operation twice.

Answer 2

You can do it this way:

FDConnection1.TxOptions.AutoCommit := False;