NextPVR DataBase

[puck64]

Hi All,

Is the NextPVR Database set to auto commit?

[JavaWiz]

Depends on the code. If the SQL is wrapped in BEGIN/END TRANS, then it commits on the END, otherwise it commits on each add/update/delete call.
http://sqlite.1065341.n5.nabble.com/what...47923.html

[sub]

My understanding is the SQLite OLEDB provider follows the normal rules for OLEDB providers transaction scope. ie, it'll be explicitly commit after each insert/update, except those that are in a multi-statement transaction, in which case it'll commit when the transaction is explicitly committed.

[puck64]

Depends on the code. If the SQL is wrapped in BEGIN/END TRANS, then it commits on the END, otherwise it commits on each add/update/delete call.
http://sqlite.1065341.n5.nabble.com/what...47923.html

My understanding is the SQLite OLEDB provider follows the normal rules for OLEDB providers transaction scope. ie, it'll be explicitly commit after each insert/update, except those that are in a multi-statement transaction, in which case it'll commit when the transaction is explicitly committed.

Thank you.

I was hoping that was the case. I kept on getting an error code of "1" when I did a commit.
The Code .....
stepRC = oosqlFinalize(stmt);

sqlStatement = 'commit;'
stepRC = oosqlPrepare(dbConn, sqlStatement, 'stmt')

stepRC = oosqlStep(stmt)

logfile~lineout('(Season_Eps) - Commit return code = '||stepRC)