Hi Nuno, I'm using VB.Net 2002 so I don't think I can use these commands.
Many thanks John On 12/07/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
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
