I have a process that repeatedly, once a second, inserts data into the
database.
I open the database, on the class instantiation.
once a second I call a function that;
exec a "BEGIN IMMEDIATE", with a sleep loop if I can't acquire the
reserved lock.
Then prepare, step, finalize, exit the function
When I come back into the function and exec a "BEGIN IMMEDIATE" I get an
error
"Cannot start a transaction within a transaction".
Whats wrong? Doesn't sqlite3_finalize(stmt), release the locks,
deletes the prepared statement and causes the database to be updated?
Why does the engine think I'm still in a transaction?
thanks,
Scott
--
-
The only security of all is in a free press. The force of public opinion
cannot be resisted when permitted freely to be expressed. The agitation it
produces must be submitted to. It is necessary, to keep the waters pure.
Thomas Jefferson to Lafayette, 1823. ME 15:491
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
