> I tried to see what MS SQL would do but it does not allow creation of the
> tables primary key with any NULL segments.
This is the correct behavior; I thought SQLite enforced that. You
can duplicate the correct behavior by adding to the
spec for each PK column.
> Does that mean I need to do my
lopment Support / FLEXquarters Solutions Consultant
QODBC Driver for QuickBooks - Unleash your data at www.qodbc.com
-Original Message-
From: Dan Kennedy [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 11:40 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Null values i
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'
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"))
4 matches
Mail list logo