subject:"RE\: \[sqlite\] Null values in Primary Key"

Re: [sqlite] Null values in Primary Key

2005-09-05 Thread Kurt Welgehausen

> 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

RE: [sqlite] Null values in Primary Key

2005-09-05 Thread Matt Froncek

iver 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 in Primary Key NULL = NULL is false. It's an SQL thing - go

Re: [sqlite] Null values in Primary Key

2005-09-03 Thread Dan Kennedy

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