Subject | Re: [firebird-support] Temporary sets of data |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-11-26T18:46:17Z |
> Hi,I use FB 2.5 !Yes, there are global temporary table (GTT). You have to define and
> 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.
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/