Hello,
I couldn't find an answer to my question, but maybe it's really simple... Is there any way to determine whether the database is currently inside a BEGIN...END transaction block? The only way I can think of at the moment is to check whether SQLITE_BUSY is returned, but I'm not sure whether that's the correct way to go. What I need to do, basically, is - I have a long transaction running (processing thousands of files, committing every 1000 files, for example), during that time, I may have some new files coming in from a separate thread. I'd like to get those new files in, so I'd like to stop the current running transaction (COMMIT), then insert the new records inside a transaction and then BEGIN a new transaction to continue processing those files (of course only if there was a transaction active in the first place - that's why I need to check if there is one running or not). Any advice greatly appreciated - thanks in advance! Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
