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.
?
----- Original Message -----
From: "Kiel W." <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, July 07, 2005 2:52 PM
Subject: Re: [sqlite] My first post, a few wishes..
On 7/7/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote:
1) I wish for a better way to recreate a table's definition.
The FAQ example is no good if you are unknown to it's fields.
For example, imy dbms obtains the create table query for the user, he
might
want to reset table name as add or remove fields.
After that the copy as suggested in the FAQ does not know what fields to
use.
SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;
Is this what you are after? This is (9) of the FAQ.
See also #2
2) Empty table does not return fields.
After i create a table + fields, there seems to be no way to enumerate the
fieldnames if there isn't any data inserted.
Both cols and rows return 0.
I'm using sqlite3_get_table()
I heard before to make use of prepare but i can't figure out how.
3) May i suggest a better (easier) forum for sqlite?
I can setup a forum independant of my own sites.
No commercials etc..
--
Kiel W.
[EMAIL PROTECTED]
----------------------------------
time is swift <<
