Re: [sqlite] Structural detection of AUTOINCREMENT

2008-06-17 Thread Dennis Cote
Csaba wrote: > >> BTW, the autoincrement keyword must appear after the integer primary key >> phrase, not in the middle as you have show it. > > This was an interesting note. I am using the SQLite that came with my > PHP v. 5.2.6 (built Feb 13, 2008), which is SQLite 2.8.17. > Turns out that

Re: [sqlite] Structural detection of AUTOINCREMENT

2008-06-16 Thread Csaba
Thanks for your reply (and also thanks, Richard, for your reply about sqlite3_table_column_metadata) I've interspersed a few remarks, please see below. On Mon, Jun 16, 2008 at 4:50 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Csaba wrote: >> Is there any way to detect, based strictly on querying

Re: [sqlite] Structural detection of AUTOINCREMENT

2008-06-16 Thread Dennis Cote
Csaba wrote: > Is there any way to detect, based strictly on querying the structure of a > table/database > whether there is an AUTOINCREMENT set? That is to say, without analyzing > the > original SQL creation statement, and without inserting a new element into > the database. > Yes there is.