I am trying to do a record count on a filtered MySQLTable (DAC for MySQL) within Delphi7. When I look at the record count on the filtered table it comes up with the total amount of records disregarding the filter. What am I doing wrong?
My code goes like this:
MySQLTable1.Active := True;
MySQLTable1.Filter := 'SupplierNo = ''ABC''';
MySQLTable1.Filtered := True;
Edit1.Text := IntToStr(MySQLTable.RecordCount);
In a Delphi DBGrid, the results are good, but the recordCount isn't.
😮