SQLite Locking

Bob Sneidar bobs at twft.com
Tue Nov 30 20:37:44 EST 2010


Have you tried this? 

.timeout MS            Try opening locked tables for MS milliseconds

Set that to 2000 for a 2 second "retry" on the cheap maybe?

Bob


On Nov 30, 2010, at 4:13 PM, Peter Haworth wrote:

> Good idea, but it got thrown back with an error.  It's not a valid SQL statement, just something the tcl/c api understands I think.  Not a big deal though, it's pretty easy to set that timeout loop in within LC.
> 
> Pete Haworth
> 
> On Nov 30, 2010, at 12:05 PM, Bob Sneidar wrote:
> 
>> Did you try to issue this as a query, with and without substituting db1 with your database name?
>> 
>> Bob
>> 
>> 
>> On Nov 29, 2010, at 4:46 PM, Peter Haworth wrote:
>> 
>>>> db1 timeout 2000
>>>> The argument to the timeout method is the maximum number of milliseconds to wait for the lock to clear. So in the example above, the maximum delay would be 2 seconds.
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list