Hi,

At Wednesday, November 26, 2008, 1:25 AM, Hans wrote:

> Not possible to sub-filter in TIBOQUERY

It 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 filter
> and then sub-filter this Tempory Dataset in TIBOQUERY

> Or receive the first filter results in a TMemoryDataset
> and basically do the same

And, that would be another option. Load all the data into a memory
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)