2012/5/2 Ed Leafe <[email protected]> > On May 2, 2012, at 7:56 AM, Charles Brunet wrote: > > > My database is (SQLite): > > > >> CREATE TABLE contacts ( > >> ID INT PRIMARY KEY NOT NULL, > >> [First Name] TEXT, > >> [Last Name] TEXT, > >> Email TEXT > >> ); > > > > > > What is wrong? Souldn't the ID field be autoincremented? > > Not unless it is defined with the 'AUTOINCREMENT' column > constraint. >
Ok, I figured out. PK needs to be INTEGER, not INT. Thank you for the tip. Charles. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/CAJPgzx=+Cecnr_3-GhEf8K5=y-pz5gbrct8uce8b_nt_de9...@mail.gmail.com
