I'm using Lazarus for 10 years now, my current version is 1.4.4 and so far I've used mostly MySQL/MariaDB, my usual code to connect to a database server looks like :
MySQL50Connection1.Connected:=false;
MySQL50Connection1.HostName:=myipaddress;
MySQL50Connection1.UserName:=myusername;
MySQL50Connection1.Password:=mypassword;
MySQL50Connection1.Database:=mydatabase;
MySQL50Connection1.Connected:=true;
and the code to insert a recod would be:
sqlquery1.close;
sqlquery1.sql.clear;
sqlquery1.sql.add('insert into mytable (field1, field2) values ("abc", "defg") ');
sqlquery1.execsql;
SQLTransaction1.CommitRetaining;
In the ObjectInspector, under the SQLTransaction's properties I can see a property "Action" and possible values are : caCommit, caCommitRetaining, caRollback, CaRollbackRetaining, caNone.
So far I have never pay any anytention on this and always left it to its defaults.
What can it be used for?
Is there documetation on this? I've done some search but could not find anything.