Advertisement
Gov_777

Выборка дат с условием

Dec 21st, 2016
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 0.35 KB | None | 0 0
  1. procedure TLog.N20081Click(Sender: TObject);
  2. begin
  3. DM.ADOQuery1.SQL.Clear;
  4. DM.ADOQuery1.SQL.Add('SELECT * FROM brut WHERE datager BETWEEN #01/01/2008# AND #31/12/2008# and  LEN(TRIM(pass)) > 0 and FL_Sale = false and AUCTHION = false and SMI_BAN = false');
  5. DM.ADOQuery1.Active:=True;
  6. Log.Caption:='Всего: '+inttostr(dm.ADOQuery1.RecordCount);
  7. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement