On 2012.09.21 10:12 PM, HECTOR RIOS wrote:

>
> Hi,
> I´m trying to save some sql parsing in a Delphi application by using
> temporary result sets. Is there such thing in Firebird?
> For example: some user makes a query with some filters and then wants
> to make another query over results from previous query.
> It would be easy if added the filters over the result set without
> having to mix previous filters plus last query´s filters.
> Anybody has an easy alternative for this?
>

You can run the query with the new filter or if you have a dataset
populated from first query you can filter data from dataset with filter
condition without interrogating again the server, this is from UI controls.
I don't know equivalent in Delphi but from c# i can do:

private void tbFilter_KeyUp(object sender, KeyEventArgs e)
{
if (tbFilter.Text.Length > 0)
{
bsProducts.Filter = "PRODUCTNAME LIKE '%"+
tbFilter.Text+"%'";
}
else
{
bsProducts.Filter = "";
}
}
bsProducts is populated running the main query.

HTH,
Paul MERCEA



[Non-text portions of this message have been removed]