Okay, I posted there, but can you tell me if this is correct SQL for the AUTOINCREMENT situation, SQLite3 didn't complain at all so I assumed it was okay?
CREATE TABLE NewEmployees(EmployeeID INTEGER PRIMARY KEY AUTOINCREMENT, LastName TEXT, FirstName TEXT); > This question is probably better asked on the SQLite.NET sourceforge > forum. > By the way, I don't know the answer. > > Tim > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] >> Sent: Monday, February 28, 2005 10:22 PM >> To: sqlite-users@sqlite.org >> Subject: [sqlite] Does SQLite.NET not support AUTOINCREMENT >> >> I used this SQL: >> >> CREATE TABLE NewEmployees(EmployeeID INTEGER PRIMARY KEY >> AUTOINCREMENT, LastName TEXT, FirstName TEXT); >> >> and using SQLite3.exe did this >> >> SQLite3 employees.db >> .read create.sql >> .exit >> >> which created my database but no tools nor the SQLite.NET >> provider can read it, I get the error "malformed database >> schema near AUTOINCREMENT? >> >> >> >> >
