[sqlite] Unique qualifier

2012-03-12 Thread Bryce Lembke
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 ;

Re: [sqlite] Unique qualifier

2012-03-12 Thread Simon Davies
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

Re: [sqlite] Unique qualifier

2012-03-12 Thread Bryce Lembke
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

Re: [sqlite] Unique qualifier

2012-03-12 Thread Bryce Lembke
] 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