Re: filer table by a word ....

From: sew crazy (
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);

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

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 ...