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 ;
On 12 March 2012 15:49, Bryce Lembke bry...@vpieng.com wrote:
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
Yes. It is odd.
I am using the cmd prompt using WindowsXP. I have also tried it on a
separate Windows7 machine with the same results.
My shell is just doing Start-run then I type cmd.
I am going to try with a different version of sqlite.
Bryce
Re: [sqlite] Unique qualifier
Simon
] Unique qualifier
Simon Davies
Mon, 12 Mar 2012 09:18:58 -0700
On 12 March 2012 15:49, Bryce Lembke bry...@vpieng.com wrote:
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