Thank you Michael. I can't find anything in the documentation about the -cmd switch. Will you point me in the right direction? Also, a 2 second timeout would be .timeout 2000 , right?
John On Thu, Sep 27, 2012 at 8:36 AM, Black, Michael (IS) <michael.bla...@ngc.com > wrote: > Try the -cmd switch. Probably the easiest solution. > > > set xxx to do shell script "sqlite3 -cmd \".timeout 2\" " & databasePath > & " \"select * from "& table1 & ";\"" > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit > Northrop Grumman Information Systems > > ________________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of John [sql...@johneday.com] > Sent: Thursday, September 27, 2012 7:12 AM > To: sqlite-users > Subject: EXT :[sqlite] Sending SQLite3 .timeout command in Command-Line > Mode > > Hi, > > I have several different computers running an AppleScript that queries and > writes to a SQLite3 database located in a shared folder on the network. > Occasionally a "database is locked" error is produced. Is there a way of > sending a .timeout command as if I was working from the shell, in > Command-Line Mode? I understand I can write an error handler which will > accomplish the same thing but I am trying to avoid that option. > > property databaseFolder : POSIX path of (path to public folder as text) & > "Databases/" > property databaseName : "myDatabase" > property databasePath : quoted form of (databaseFolder & databaseName > astext) > property table1 : "Main" > > set xxx to do shell script "sqlite3 " & databasePath & " \"select * > from "& table1 & "; > \"" > > Thanks. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
