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

2005-03-01 Thread Kurt Welgehausen
> ... can you tell me if this is correct SQL ... ? Yes, it's correct.

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

2005-03-01 Thread mike . griffin
y 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

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

2005-03-01 Thread Eric Bohlman
[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 it

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

2005-03-01 Thread Tim McDaniel
g > 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

[sqlite] Does SQLite.NET not support AUTOINCREMENT

2005-02-28 Thread mike . griffin
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 "ma