[sqlite] error during bind

[Clemens Ladisch]

Kumar Suraj wrote:
> BEGIN TRANSACTION; INSERT INTO TBL (dn) VALUES (?); SELECT 
> last_insert_rowid(); COMMIT;

Please note that the value returned by the SQL function "last_insert_rowid()"
is also available with the C API function "sqlite3_last_insert_rowid(db)".

When you have SQL commands without parameters and without a result, it is
easier to execute them with sqlite3_exec():

    rv = sqlite3_exec(sqlHandle->db, "COMMIT;", NULL, NULL, NULL);
    if (rv != SQLITE_OK) ...


Regards,
Clemens