Subject Re: [firebird-support] Temporary sets of data
Author Thomas Steinmaurer
> Hi,I use FB 2.5 !
> I'm writing a store procedure,and there I need some sets of data stored temporary to use only in my SP,I also need to update/delete it
> Is there is a easy way to do this with firebird?
> I also found there are temporary tables,but I don't know how to use or if is what I need.

Yes, there are global temporary table (GTT). You have to define and
create a GTT like any other table and metadata are globally visible, but
the scope of the data is bound to a transaction or a connection.

More on GTT is available here:
http://www.firebirdsql.org/refdocs/langrefupd21-ddl-table.html


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/