SQLite install
SQLite install
- Subject: SQLite install
- From: BareFeet <email@hidden>
- Date: Mon, 2 Jun 2008 10:11:22 +1000
The problem appears to be the statement "create table if not
exists Contacts"
IRC, support for the "if not exits" clause has been added somewhere
between versions 3.1.x and 3.4.x of SQLite.
So, could above discrepancy just be a matter of Tiger vs Leopard?
Good catch, Alex. According to SQLite's web site at:
http://www.sqlite.org/changes.html
2006 October 9 (3.3.8)
• Added support for IF EXISTS on CREATE/DROP TRIGGER/VIEW
My Leopard Mac shows SQLite version 3.4.0 whereas Tiger shows SQLite
version 3.1.3.
So, yes, that would explain the discrepancy.
Of course, you can install the latest version (currently 3.5.9) of
SQLite on any Mac OS version by downloading from:
http://www.sqlite.org/download.html
You can either download the source code and do the usual "make
install" for C software. Or if you just want the binary of the shell
command, you can download the "Precompiled Binaries For Mac OSX"
"command-line program" (Safari should decompress the .zip into
the .bin file), rename the resulting ".bin" file to
"sqlite3" (ensuring no ".bin" file name extension), set unix execute
permission, and probably move it into /usr/local/bin/sqlite3. Then
refer to its full path from within the Applescript "do shell script"
command.
Tom
BareFeet
--
Comparison of SQLite programs for Mac OS X:
http://www.tandb.com.au/sqlite/compare/?ml
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden