On 10/26/06, T&B <[EMAIL PROTECTED]> wrote:
On 17/10/2006, at 9:31 PM, Martin Jenkins wrote:
> Does the SQL output work for your application? Might be just as
> easily parseable as yet-another-version-of-CSV...
I originally dismissed the sql "insert" output mode as most likely
having the same bug as csv. Upon checking, however, the insert mode
seems to work perfectly, handling commas and returns/linefeeds within
quotes, as well as substituting a quote within a quote with a double
quote.
..
For those who asked, I'm building an application using "AppleScript
Studio", which is basically Apple's Xcode development environment,
using AppleScript as the programming language. SQLite is built into
Mac OS X, and can be called via shell scripts. Within AppleScript,
this looks something like:
do shell script "sqlite3 Test.sqlite 'CREATE TABLE Test( field1 );'"
If anyone knows how to instead directly (ie not via a shell script)
call the SQLite routines in Mac OS X, I'm all ears :-)
what do you mean by "call the SQLite routines"? You can use any number
of programming languages to do so just as you are doing with Apple
Script. I use Perl, but you could use Perl, Python, PHP, Tcl, C, and
even Objective C. Did you explore Quicklite? I believe I had sent that
link a few days ago... it is a Cocoa wrapper around SQLite create by
Tito Ciuro. Looks quite good.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
-------------------------------------------------------------------------------------------------------
collaborate, communicate, compete
====================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
