select * TableSalarie where champ1 is not null and champ2 is not null
procedure TForm1.Button1Click(Sender: TObject); begin ADOQuery1.Open; with ADOQuery1.SQL do begin Clear; Add('SELECT * From Matable'); Add('WHERE (CHAMP1 is Not NULL) OR'); Add('(CHAMP2 := param '); ADOQuery1.FieldByName('parame').Value := MaValeur; ADOQuery1.Open; end; end;
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionprocedure TForm1.Button1Click(Sender: TObject); begin ADOQuery1.Open; with ADOQuery1.SQL do begin Clear; Add('SELECT * From Matable'); Add('WHERE (CHAMP1 is Not NULL) AND'); Add('(CHAMP1 <> ''); ADOQuery1.Open; end;