On 10/9/06, T&B <[EMAIL PROTECTED]> wrote:
Hi He,
>> sqlite3 Disney.db "SELECT * FROM Characters"
>>
>> When I get the result of a SELECT statement, the output has
>> columns separated by pipe characters and rows by new lines. So, if
>> a value contains a return, it prematurely starts a new line, and
>> messes up my output result.
> Well, you didn't say which midware or platform were you using. I'll
> talk in the perspective of C API.
At the moment I'm just prototyping, on a Mac, using Xcode for the UI
and AppleScript calling sqlite via shell commands. I may move
sections of it over to C in the long term, once I have it all
working. But for now, my only interface to sqlite is via the sqlite3
shell command.
> In reality, we never parse query results directly from the "table"
> output from command line shell.
..
What is QuickLite?
QuickLite is a Cocoa wrapper for SQLite, a C library that implements
an embeddable SQL database engine.
See more at <http://www.webbotech.com/>
--
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/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
