Subject | Re: [IBO] TIBOQuery : Filtering records without refreshing |
---|---|
Author | Daniel Rail |
Post date | 2008-11-26T12:30:16Z |
Hi,
At Wednesday, November 26, 2008, 1:25 AM, Hans wrote:
the OnFilterRecord event, and have the Filtered property set to True.
dataset and use its Filter property.
But, if it's a multi-user application, neither of these methods would
permit to fetch new data from the database, unless the user has a
button that would force a refresh of the dataset.
--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At Wednesday, November 26, 2008, 1:25 AM, Hans wrote:
> Not possible to sub-filter in TIBOQUERYIt is possible. But, not with the Filter property. You have to use
the OnFilterRecord event, and have the Filtered property set to True.
> Maybe create a Temporary DataSet using the first filterAnd, that would be another option. Load all the data into a memory
> and then sub-filter this Tempory Dataset in TIBOQUERY
> Or receive the first filter results in a TMemoryDataset
> and basically do the same
dataset and use its Filter property.
But, if it's a multi-user application, neither of these methods would
permit to fetch new data from the database, unless the user has a
button that would force a refresh of the dataset.
--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)