Re: filer table by a word ....

From: sew crazy (sew.crazy_at_webmail.co.za)
Date: 03/22/05


Date: Tue, 22 Mar 2005 19:54:50 +0200

thanx for the advice will spend some time going through the help file
on filter ....

ok for now I've tried this ....

procedure TForm1.BitBtn4Click(Sender: TObject);

var
   DateStr, SQLStr : string;
begin
// DateStr := FormatDateTime('YYYY-MM-DD', MonthCalendar2.Date);
// DateStr := '2005-03-18';
   SQLStr := Format('SELECT * FROM AdoTable1l WHERE DateIn =
''%s''',[DateStr]);
   adotable1.Filtered := True;
end;

Neither of the 2 disabled lines gives me any result ...
the date format in my db is displayed as yyyy/mm/dd

i get no errors when i run the code with any of the lines enbled
however all the data is still displayed ...