Yep, these dot commands only mean anything to the sqlite3 command line
program, not SQlite itslef. I thought of executing a script to issue
the .time but honestly, the LC loop is 6 lines of code so it's not a
big deal to keep it in LC.
STill got to get around to doing my tests over a network though.
Pete Haworth
On Dec 1, 2010, at 10:09 AM, Bob Sneidar wrote:
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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
