DB.SQLExecute("BEGIN TRANSACTION")
...
If Not DB.Error Then
DB.Commit
Else
...
Why should execute a SQL command instead of a simple method like the commit?
I know there are other requests for this same thing but this is what I found in a quick Feedback search: <https://xojo.com/issue/25257>
FWIW, you can create your own by using the Extends method to the database class.
Probably because ‘BEGIN TRANSACTION’ has options such as IMMEDIATE, DEFERRED, DISTRIBUTED.
SQLite also allows named ‘SAVEPOINT’ transactions.
COMMIT is a standalone operation that ends whatever you started earlier.
Commit & Rollback can have params as well depending on DB
see https://msdn.microsoft.com/en-CA/library/ms190295.aspx, http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4010.htm,
They USUALLY dont though
It really depends on the DB and what it permits as to what you can / will need to do