Is there any way to get a list of all column names in a table via the C API, which works even when there are no data rows in the table?

The example given for sqlite3_get_table() indicates that the column names are returned as the "zeroth" row. Indeed, it states:

"In general, the number of values inserted into azResult will be ((*nrow) + 1)*(*ncolumn)."

However, I when the table has no data rows, the returned ncolumn=0, so the expression evaluates to 0 and indeed I get 0 values.

Thanks,

Jerry Krinock

(Using sqlite 3.4.0, as shipped in Mac OS X version 10.5)

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to