Re: TADODataset.Filter?

The following code works fine for me using either a ADOQuery or ADODataSet.
The actual SQL text was
'select * from Employees'
from the MsSql NorthWind database.


procedure TForm1.Button1Click(Sender: TObject);
begin
// ADOQuery1.Close;
// ADOQuery1.Filter := 'LastName Like ' + QuotedStr('Fu*'); //Fuller
// ADOQuery1.Filtered := true;
// ADOQuery1.Open;
ADODataSet1.Close;
ADODataSet1.Filter := 'LastName Like ' + QuotedStr('Fu*'); //Fuller
ADODataSet1.Filtered := true;
ADODataSet1.Open;
end;

.

Quantcast