SQLite Locking

Bob Sneidar bobs at twft.com
Wed Dec 1 13:09:54 EST 2010


NVM I tried it. I guess it's only a shell command. Still, you might wanna try shelling into the database before opening it and executing this command. Check out this link: 

http://www.sqlite.org/sqlite.html

Bob

> 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