[Gambas-devel] SAVEPOINT suport and nested standard transactions
gambas at ...1...
Thu Nov 28 18:46:55 CET 2013
Le 28/11/2013 17:42, PICCORO McKAY Lenz a écrit :
> Reading documentastion for transactions i note that only mysqlito
> support that and only by fes engines.. so then sqlite, postgres and
> odbc do not support..
> since sqlite 3.6.16 and sybase 12 (including anywhere) support
> SAVEPOINTS m,y question its:
> Does gambas have the support into languaje for hconn.SavePoint(Optional
> label) or hconn.SaveRelease(Optional label)?
> due i do not see into documentation!
> 1) http://en.wikipedia.org/wiki/Savepoint
> 2) http://en.wikipedia.org/wiki/Nested_transaction
> Lenz McKAY Gerardo (PICCORO)
There is no support for that in gb.db, as I'm not sure it is possible in
the three DBMS supported by Gambas (PostgreSQL, MySQL and SQLite).
But you can use the Exec() method to issue any SQL command you want, so
if there is a standard syntax for savepoints, I think you will be able
to deal with that.
More information about the Devel