Subject | Re: [ib-support] temp table |
---|---|
Author | Artur Anjos |
Post date | 2003-05-13T09:24:01Z |
Regina:
You can't.
There are lots of alternatives.
One example:
Your 'temp table' as always the same fields? If so, create the table, and
use a generator to track the rows affected. This way you can create the
rows, use them, and after that delete them.
Artur
You can't.
There are lots of alternatives.
One example:
Your 'temp table' as always the same fields? If so, create the table, and
use a generator to track the rows affected. This way you can create the
rows, use them, and after that delete them.
Artur
----- Original Message -----
> I need to create a temporary table inside a store procedure. And once I
called the store procedure, I want to delete that temporary table
automatically.
> How should I do this?
> Anybody has a good reference?
>
> Thanks,
> Regina