RobertoN Posted April 4, 2019 Share Posted April 4, 2019 Hello ppl ! I changed from FireDAC to DEVART MyDAC because this problem I didin't find solution... Ex.: (TFDConnection X MySQL) UniMainModule.FDConnection.Open; UniMainModule.FDConnection.StartTransaction; UniMainModule.FDConnection.ExecSQL('INSERT INTO test(mystr) VALUES (''xxxxxx'');'); UniMainModule.FDConnection.ExecSQL('INSERT INTO test(mystr) VALUES (''yyyyy'');'); UniMainModule.FDConnection.Close; //I closed without do the commit, but at this moment commit occurs on database !??? //I think if FDConnection.inTransaction so onClose must be Rollback, but Commit happens !? With TMyConnection all works fine... Well, but what is the solution to FireDAC ? The commit occurs when shutdown too, but this is very wrong .... Roberto Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.