• Welcome, Guest. Please login.
 
May 26, 2019, 04:28:48 am

News:

Welcome to the SQLitening support forums!


sqlite3_busy_timeout

Started by Bern Ertl, January 08, 2009, 02:30:39 pm

Previous topic - Next topic

Bern Ertl

Fred, in the source for SQLiteningProcsA.BAS, you have a MACRO defined for slmOpen that calls sqlite3_busy_timeout() if there is an error with the sqlite3_open_v2() call.  I checked the sqlite function definition and it's not clear to me why you are calling this function in this case.  Why call it?

Fred Meier

I think you misread the code.  The set busy timeout is called only if there is no error.
   if isfalse llRC then
      sqlite3_busy_timeout whDab, 10000
   end if
The default SQLite busy timeout (waiting for a lock) is zero.  This code tells SQLite to retry getting a lock for 10 seconds before reuturning a busy error.