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.
My prototype is currently my reality ;-)
You are supposed to use a combination of sqlite3_open,
sqlite3_prepare, sqlite3_step, which are the APIs provided by
sqlite, to access the database. And use APIs like sqlite3_column_*
to get the content of the query.
Thanks for the detail. I may have to take the plunge into C, but not
yet. Unless someone has tips or a skeleton in how to integrate the
SQLite C routines into Xcode.
Any other help appreciated.
Thanks,
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
