On 7/12/06, John Newby <[EMAIL PROTECTED]> wrote:
Hi, how can I find out the names of the fields within a given table?
I've tried "pragma table_info(test);"
but this brings back too much info, I just require the names as I'll be
storing them in an array within my application.
When you use pre-compiled SQL statements you get that info for free,
that is, whitout actually needing to run the query. Look the
sqlite3_column_name function:
* http://sqlite.org/capi3ref.html#sqlite3_column_name
Regards,
~Nuno Lucas
Many thanks
John
