[sqlite] select with no results

[Michael Hunley]

I was attempting to use a feature of select to retrieve some schema 
information.  I was using the fact that the first row returned from select 
is the list of column names, so "select * from <table>" gives me the list 
of columns for some diagnostics.  However, SQLite does not return this row 
if there are no results, from setting limit 0, from a where clause that 
finds no results or if there is no data yet in the table.  Is that correct 
behavior?  In Mysql, for instance, I can get an empty result set back and 
still call the API to get meta info about the results (field names, etc).

Is my only option to parse the SQL statement that created the table in the 
first place (seems like redundant work since SQLite already did this for me)?

Also, is there any plans to allow a select or add an API call to extract 
the type label for a column?
What about to retrieve the array of lengths of each result row?  It would 
seem that SQLite has that info and it could be made available pretty 
easily, renmoving redundant work of calling strlen on each field if you 
need to know that info.  Just a thought/humble request.

thanks.

Michael Hunley
Senior Engineer
PocketPurchase, Inc.  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]