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
