Re: [sqlite] My first post, a few wishes..

[Edwin Knoppert]

I'm not using c and thus i do not compile the source into my app :)
So i'm calling sqlite3_get_table() to obtain data.
It's purely to instruct the sqlite 3 dll, think as if i'm where using VB6 
(without some 'odd' wrapper/helper dll's)
I'm actually using PowerBASIC - PB/WIN80.
I'm also having trouble obtaining the field types, but that will be another 
post.




----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Cc: "Kiel W." <[EMAIL PROTECTED]>
Sent: Thursday, July 07, 2005 3:35 PM
Subject: Re: [sqlite] My first post, a few wishes..


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>