On 9/21/12 3:12 PM, HECTOR RIOS wrote:

> 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?

Sounds like you need to use global temporary tables. These can have a
lifetime of the connection to the database which sounds like what would
be appropriate.

See http://www.firebirdsql.org/refdocs/langrefupd21-ddl-table.html

Doug C.