Subject TIBOQuery : Filtering records without refreshing
Author scr0546
Hello,

I'm working with TIBOQuery and want to filter the records locally at
clientside without refreshing the dataset from server.
When using the filter-property of the dataset the data are always
reloaded from server when the filter-condition changes.

How can I filter records at clientside with TIBOQuery?
The main performance-problem is when I set Filter:='' or
Filtered:=false, because all records will be refreshed.

For example:
1. FetchAll from server (about 30.000 customerrecords)
This happens at startup.

2. Filtering/Searching at clientside (like "name containing 'xyz'")

3. It's not important to refresh the dataset all the time when the
filtercondition changes or when I clear the filter to see all
records again.

Thanks for help
Joe