Michael Hunley wrote:
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?
You need to use:
PRAGMA empty_result_callbacks = ON;
Check out the PRAGMA
Try sql: "PRAGMA table_info("table_name");" or sql:"select * from
sqlite_master"
Brona
> -Original Message-
> From: Michael Hunley [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 09, 2003 8:10 PM
> To: [EMAIL PROTECTED]
> Subject
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 " gives me the list
of columns for some diagnostics. However, SQLite does not return this row
if there a
3 matches
Mail list logo
