dbCommit#

Purpose#

Commits a transaction to the database if the driver supports transactions and a dbTransaction() has been started.

Format#

ret = dbCommit(db_id)#
Parameters:

db_id (scalar) – database connection index number.

Returns:

ret (scalar) – 1 for success or 0 for failure.

Examples#

// Add `SQLITE` to list of database connections
db_id = dbAddDatabase("SQLITE");

// Execute query
dbExecQuery(db_id, "INSERT INTO PEOPLE
    (first, last) VALUES ('John', 'Doe');");

// Commit transaction
dbCommit(db_id);

// Close database
dbClose(db_id);

Remarks#

For some databases, the commit will fail and return 0 if there is an active query using the database for a SELECT statement. Make the query inactive before doing the commit to resolve this problem.

Call dbGetLastError() to get information about errors.