filter question

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ben
Posts: 119
Joined: Wed 17 Nov 2004 19:48

filter question

Post by ben » Wed 12 Mar 2008 16:29

I have an opened Query and then I:

Query1.Filter := 'title like "something%"';
Query1.Filtered := true;

and then

Query1.Filtered := false;


Does this reload records from MySQL or it happens to memory only?

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 13 Mar 2008 16:19

This kind of filtering is performed locally, and does not request data from server.
If you use FilterSQL instead, MyDAC will request data from the server each time the value of FilterSQL gets changed.

Post Reply