[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 Bryce Lembke
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 fine. C:\sqlite

Re: [sqlite] Unique qualifier

2012-03-12 Thread Bryce Lembke
OK. I moved to 3.7.10 and it works fine now. I was using the 3.6.17 that was included with EJSCRIPT. I am wondering if there is an issue with that one, but I am good for now. Thanks. Bryce From: Bryce Lembke Sent: Monday, March 12, 2012 1:38 PM To: 'sqlite-users@sqlite.org' Subject