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
