Thanks so much Thomas !



________________________________
From: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com
Sent: Monday, November 26, 2012 8:46 PM
Subject: Re: [firebird-support] Temporary sets of data


 

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




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