Subject | Re: [IBO] TIBOQuery : Filtering records without refreshing |
---|---|
Author | Hans |
Post date | 2008-11-26T05:25:38Z |
Not possible to sub-filter in TIBOQUERY
Maybe create a Temporary DataSet using the first filter
and then sub-filter this Tempory Dataset in TIBOQUERY
Or receive the first filter results in a TMemoryDataset
and basically do the same
Maybe create a Temporary DataSet using the first filter
and then sub-filter this Tempory Dataset in TIBOQUERY
Or receive the first filter results in a TMemoryDataset
and basically do the same
----- Original Message -----
From: "scr0546" <pub@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, November 25, 2008 5:38 PM
Subject: [IBO] TIBOQuery : Filtering records without refreshing
> 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
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>