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?



Reply via email to