Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionprocedure TForm1.Button22Click(Sender: TObject); begin Query1.Close; Query1.Open; Query1.Filtered := false; Query1.Filter := 'SaleDate>=' + QuotedStr('05/06/1990') + 'and ShipDate<=' + QuotedStr('05/08/1989'); Query1.Filtered := true; end;
procedure TForm1.Button6Click(Sender: TObject); begin with Query1.SQL do begin Clear; Query1.Close; Add('Select * from orders '); Add('Where (SaleDate >=:Deb) and (ShipDate <=:Fin) '); Add('Order by SaleDate, ShipDate '); Query1.ParamByName('Deb').AsDate := MCDEBUT.Date; Query1.ParamByName('Fin').AsDate := MCFIN.Date; Query1.Open; end; end;
procedure TForm1.Button24Click(Sender: TObject); begin with Query1.SQL do begin Clear; Query1.Close; Add('Select * from orders '); Query1.Open; end; end;
procedure TForm1.Button22Click(Sender: TObject); begin Query1.Close; Query1.Open; Query1.Filtered := false; Query1.Filter := '(' + 'SaleDate>=' + QuotedStr('05/06/1990') + ')'+ ' and (' + 'ShipDate<=' + QuotedStr('05/08/1989')+ ')'; ShowMessage (Query1.filter); Query1.Filtered := true; end; mais toujours un petit souci avec les blancs qui pourraient être réglés je pense en ajoutant : ((A>= date1) and (A <>'')) and ((B <= Date2) and (B <>''));
type ODBCDateTimeFormats = ( FormatDate, FormatHeure, FormatDateHeure); //Fonction pour mettre date et heure au format sql function DateTimeToODBCDatetime(DateTime: TDateTime; Format: ODBCDateTimeFormats):string; begin case Format of FormatDate : Result := #123' d ' +QuotedStr(FormatDateTime('yyyy-mm-dd',DateTime))+'}'; FormatHeure: Result := #123' t ' +QuotedStr(FormatDateTime('hh:nn:ss',DateTime))+'}'; FormatDateHeure : Result := #123' ts '+QuotedStr(FormatDateTime('yyyy-mm-dd hh:nn:ss',DateTime))+'}'; end; end;