[sqlite] and , or

[Eggert, Henri]

Hi sqlite-users

Works fine : select Id from Data where ( ( Text = '' ) or ( Comming = ''
) )
But NOT    : select Id from Data where ( ( Text = '' ) and ( Comming =
'' ) )

Any help would be appreciated.

Thanks's

Henri


PS : The table has been created with :

CREATE TABLE Data 
( 
  Id integer primary key         
, Date Date         
, Text Text         
, Comming Text      
, Going Text   
, .....   
, constraint c1 unique ( Date )        
 )