Hi, I want to select the records which have both columns Text and Comming empty.
I have found that the problem is the column name "Text". If I replace the column name "Text" by another all works fine. So I wonder : is "Text" a keyword for sqlite ? Thank's Henri -----Ursprüngliche Nachricht----- Von: Gerald Dachs [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 18. Oktober 2005 14:50 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] and , or > > Hi sqlite-users > > Works fine : select Id from Data where ( ( Text = '' ) or ( Comming = '' > ) ) > But NOT : select Id from Data where ( ( Text = '' ) and ( Comming '' ) > ) What about this: select Id from Data where ( ( Text = '' ) and ( Comming = '' )) Gerald