Re: [sqlite] Does SQLite.NET not support AUTOINCREMENT

> ... can you tell me if this is correct SQL ... ? Yes, it's correct.

RE: [sqlite] Does SQLite.NET not support AUTOINCREMENT

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

Re: [sqlite] Does SQLite.NET not support AUTOINCREMENT

[EMAIL PROTECTED] wrote: 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

RE: [sqlite] Does SQLite.NET not support AUTOINCREMENT

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]