Edwin Knoppert <[EMAIL PROTECTED]> writes:
> Sorry, i seem to have posted to another thread somehow..
>
> No you misunderstood me, i'm well able to obtain the fields but it seems not
> to have the fieldnames when no rows where inserted.
I think what you're looking for is PRAGMA TABLE_INFO(table_name)
SQLite version 3.1.3.1
Enter ".help" for instructions
sqlite> create table aaa(i integer, t text);
sqlite> .mode line
sqlite> pragma table_info(aaa);
cid = 0
name = i
type = integer
notnull = 0
dflt_value =
pk = 0
cid = 1
name = t
type = text
notnull = 0
dflt_value =
pk = 0
sqlite>
