Re: [sqlite] couldn't use is null function

2012-11-08 Thread Igor Tandetnik
On 11/8/2012 8:49 PM, YAN HONG YE wrote: sqlite> SELECT fmn,IMPLANTATIONgrading FROM T93C_ADL WHERE IMPLANTATIONgrading i s not null and fmn like '85495%'; 854954|R 854952| //-here is NULL, but I do

Re: [sqlite] couldn't use is null function

2012-11-08 Thread Simon Davies
On 9 November 2012 01:49, YAN HONG YE wrote: > sqlite> SELECT fmn,IMPLANTATIONgrading FROM T93C_ADL WHERE > IMPLANTATIONgrading i > s not null and fmn like '85495%'; > 854954|R > 854952| > //-here is

Re: [sqlite] couldn't use is null function

2012-11-08 Thread YAN HONG YE
5%'; 854954|R 854952| 854951|R 854953|R 854950|R 854959|G 854957| 854955|R 854956|R 854958| sqlite> Message: 6 Date: Wed, 7 Nov 2012 08:44:01 + From: Simon Davies To: General Discussion of SQLite Database Subject: Re: [sqlite] couldn't use is null function Message-ID:

Re: [sqlite] couldn't use is null function

2012-11-07 Thread Igor Tandetnik
YAN HONG YE wrote: > SELECT * FROM ADL WHERE Project_grading is null; > can't select anything. So there's no row in ADL where Project_grading is in fact NULL. What makes you believe differently? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-

Re: [sqlite] couldn't use is null function

2012-11-07 Thread Simon Davies
On 7 November 2012 08:27, YAN HONG YE wrote: > SELECT * FROM ADL WHERE Project_grading is null; > can't select anything. sqlite> create table ADL( id integer primary key, data text, Project_grading integer ); sqlite> insert into ADL( data, Project_grading ) values( '1', 1 ); sqlite> insert into A