OpenEuphoria

Re: SQLite update

• Posted by Tone Škoda <tskoda at email.si> Sep 07, 2005
• 709 views

Chris Burch wrote:
> 
> Hi
> 
> I've update the EUSQLite website, with the new additions by Tone Skoda.
> 
> Tone, could you please just run your eyes over it, if there's anything you're
> not happy
> with, let me know.
> 
> Also I'm having difficulty explaining the sqlite_column_* set of functions,
> would it
> be possible to have an example of usage please. (time permitting, of course)
> 
> Thanks again for the contribution.
> 
> Chris
> 
> <a
> href="http://members.aol.com/chriscrylex/euphoria.htm">http://members.aol.com/chriscrylex/euphoria.htm</a>
> <a href="http://uboard.proboards32.com/">http://uboard.proboards32.com/</a>
> <a
> href="http://members.aol.com/chriscrylex/EUSQLite/eusql.html">http://members.aol.com/chriscrylex/EUSQLite/eusql.html</a>
> 

An example of sqlite_column_* functions is in sqlite_blob.exw. Maybe rename that
file to sqlite_prepare.exw to make it clearer.

Here is the explanation of what sqlite_column_* functions do:
When you use sqlite_prepare()/sqlite_step() functions to READ from database, you
should then use sqlite_column_* functions to retrieve the data of found rows.
sqlite_column_* functions are used only when reading from database, whereas
sqlite_bind_* functions are used both when writing and reading the database.


Maybe add this info to the documentation of sqlite_step() because it's
important:

-- Returns SQLITE_DONE, SQLITE_ROW, SQLITE_BUSY, SQLITE_ERROR or SQLITE_MISUSE,
-- see http://sqlite.org/capi3ref.html#sqlite3_step
-- When reading from database, SQLITE_ROW is returned if there were any row(s)
found
-- and are ready to be read with sqlite_column_* functions.
-- SQLITE_DONE is returned if there was no row found.