The command does need to be in quotes if it's more than one word. sqilte3 expects 1 argument for the command.
I'm not familiar with applescript but I assume you have to escape quotes to make them actually appear in the output. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: [email protected] [[email protected]] on behalf of John [[email protected]] Sent: Thursday, September 27, 2012 9:02 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Sending SQLite3 .timeout command in Command-Line Mode I can't find anything about the -cmd switch outside of the official docs either! Does the command need to be escaped as it is in your example set xxx to do shell script "sqlite3 -cmd \".timeout 2\" " & databasePath & " \"select * from "& table1 & ";\"" or can I simply use ? set xxx to do shell script "sqlite3 -cmd .timeout 2 " & databasePath & " \"select * from " & table1 & ";\"" Thanks again for revealing the (apparent) -cmd switch secret. On Thu, Sep 27, 2012 at 9:44 AM, Black, Michael (IS) <[email protected] > wrote: > sqlite3 -help > > The sqlite3 shell page doesn't explain any switches...couldn't find > another page about it. Anybody??? > > And you're right on timeout -- it's in milliseconds. > > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit > Northrop Grumman Information Systems > > ________________________________________ > From: [email protected] [[email protected]] > on behalf of John [[email protected]] > Sent: Thursday, September 27, 2012 8:39 AM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] Sending SQLite3 .timeout command in > Command-Line Mode > > 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) < > [email protected] > > 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: [email protected] [[email protected]] > > on behalf of John [[email protected]] > > 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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
