API2 Db Runtime exception gDB.BeginTransaction

Databases
1

I’m getting a runtime exception on gDB.BeginTransaction.

The error is:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘TRANSACTION’ at line 1

Totally confused!

2

Pretty sure that the plugin uses the wrong syntax for starting a transaction
Manually do it using the right stuff and ExecuteSQL

Its been reported at least twice and not fixed yet
http://feedback.xojo.com/case/60656
http://feedback.xojo.com/case/58304

3

Have you tried:

gDB.ExecuteSQL ("begin transaction")

?