[SQLite] How to set a savepoint

[Kangs]

Hi,

I try to set a savepoint in this way :

if ( ! db.transaction() )
	return false;
 
//QSqlQuery query( "savepoint sp1", db );
QSqlQuery query( "savepoint sp1;", db );
if ( ! query.exec() )
	std::cerr << query.lastError().text() << '\n';

if ( ! db.transaction() )
	return false;
 
//QSqlQuery query( "savepoint sp1", db );
QSqlQuery query( "savepoint sp1;", db );
if ( ! query.exec() )
	std::cerr << query.lastError().text() << '\n';

To copy to clipboard, switch view to plain text mode 

And i've the error : No query Unable to fetch row
I no other idea on how to do it (except to use directly the sqlite API)

Do you have a idea on how to do it with the Qt API ?

Thx.

[viulskiez]

Check your sqlite driver version. SAVEPOINT first appeared in SQLITE V 3.6.8.