I used the following to upgrade SQLite 3 on 10.6.8. I now have version 3.6.12 installed in /usr/bin/ and version 3.7.14 installed in /usr/local/bin/. Was this the best way to install it?
mkdir ~/tempFolder cd ~/tempFolder curl https://www.sqlite.org/sqlite-autoconf-3071400.tar.gz | tar xvz cd sqlite-autoconf-3071400 autoconf ./configure --prefix=/usr/local make sudo make install As long as I call the latest version, the command below works perfectly. set xxx to do shell script "/usr/local/bin/sqlite3 -cmd \".timeout 2\" " & databasePath & " \"select * from " & table1 & ";\"" Thank you for your help. John On Thu, Sep 27, 2012 at 10:49 AM, Black, Michael (IS) < michael.bla...@ngc.com> wrote: > The other thing you should do is check the exit status of sqlite3. if not > 0 then an error occurred. > > Plus parse the output to see if you get any errors -- in specific handle > the errors you know about and show errors that need a handler. So for BUSY > and LOCKED you may loop for a while retrying it. > > Again..don't know how applescript does this. > > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit > Northrop Grumman Information Systems > _______________________________________________ > 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