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.