Hi.
I´m using RemoteDB this way in order to control the transactions:
RemoteDBDatabase1.BeginTransaction;
Try
XDataset1.Append;
{Fields to Save or update}
XDataset1.Post;
RemoteDBDatabase1.Commit;
Except
RemoteDBDatabase1.Rollback;
End;
This ways I control the transaction, right?
But, if in my server the FiredacConnection (TFDConnection), the property "TxOptions.AutoCommit" was true, what I have done in my RemoteDB code will works fine?
In my mind, the TxOptions.AutoCommit must be False, because I´m controling the transaction.
The code is correct, and it will behave the same way as if you are using FireDAC directly. It's exactly the same, an TFDConnection will be created server-side with the settings you have defined.
You have to check and know how FireDAC behaves. According to documentation:
If the application called the StartTransaction method, then the automatic transaction management will be disabled until the corresponding Commit or Rollback method call.