I cannot seem to get the UNIQUE constraint to work in sqlite.
The following is the trace from my command line. Note that if I remove the UNIQUE constraint, it works fine. C:\>sqlite myDB.db SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE employees (id INTEGER PRIMARY KEY,name TEXT UNIQUE); SQL error: SQL logic error or missing database sqlite> CREATE TABLE employees (id INTEGER PRIMARY KEY,name TEXT); sqlite> The examples I have seen are using this syntax, what am I doing wrong? Bryce _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users