Hi Doug,
 
With temporary tables would have to create them when I make the first query, right?
I´m looking for something simpler.
I know this feature of temporary result set is implemented on other database servers -I think Db2- and would like to know if firebird does support it but seems like not...
 
Regards,
Hector Rios


________________________________
From: Doug Chamberlin <chamberlin.doug@...>
To: firebird-support@yahoogroups.com
Sent: Saturday, September 22, 2012 7:28 AM
Subject: Re: [firebird-support] How to make queries to a temporary result set



 

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.




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