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 <[email protected]> To: [email protected] 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]
