filtered records in TTable / TADOTable?

[inetd]

If I use TTable / TADOTable with filter property, the filtered records are displayed. Is the dataset retrieving all the records in the table and just display the filtered records to us? Or, it only retrieve the filtered records from the table and with a new retrival if I changed the filter property?

I would like to know how the TTable / TADOTable handle the filter property.

Thx.

 

[hilfy]

Filters on Queries (TQuery) adds to the Where clause and you get the processing on the server IF it's a client/server database.

I think[/], however, that a filter on a TTable will read all of the records and just display those that are appropriate - that's the way it has to work if you use the OnFilterRecord event handler instead of the Filter property.

Of course, if you're using a desktop database like Paradox, xBase, or Access, all of the records get processed no matter what type of component you're setting the filter on as there is no server piece to do the processing in the first place.

-Dell