Porting an application to sqlite3.6.13 on Linux i made a mistake
creating a illegal query on a character field:
select * from Test where Remark = NULL
select * from Test where Remark <> NULL
I was confused as there were neither data nor an error. Shouldn't this
cause at least an error message?
With the correct queries
select * from Test where Remark is NULL
select * from Test where Remark not NULL
everything is fine
--
_________________________________________________________
Stefan G. R. Finzel, Dipl. Phys. (Univ.)
Ochsenkopfstr. 5, D-95478 Kemnath, +49 (0)9642 704448
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users