NULL = NULL is false. It's an SQL thing - go figure. Try: SELECT * FROM test WHERE b IS NULL;
http://www.sqlite.org/nulls.html --- Matt Froncek <[EMAIL PROTECTED]> wrote: > I am using SQLCrypt and it returns SQLite Library number 3002002. I have > tried with Encryption on and off. > > Why can't I find a record saved with NULL in one of the fields of the > primary key? > > CREATE TABLE "Test" ("A" VARCHAR(36) COLLATE NOCASE, "B" VARCHAR(36) COLLATE > NOCASE, PRIMARY KEY("A", "B")) > > INSERT INTO Test("A", "B") VALUES ('1', '1') > INSERT INTO Test("A", "B") VALUES ('2', NULL) > > SELECT * From Test WHERE B = NULL --> Returns no records > SELECT * From Test WHERE B = '' --> Returns no records > SELECT * From Test --> Returns both records > SELECT * From Test WHERE A = '2' --> Returns the second record > > Matt Froncek > QODBC Development Support / FLEXquarters Solutions Consultant > QODBC Driver for QuickBooks - Unleash your data at www.qodbc.com > > > ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
