Subject Re: temporary tables
Author Aage Johansen
Duilio Foschi wrote:
> ...
> As several users could be working on the same query, I build the name of
> the temporary table by adding a suffix and a number given by a generator.
> In this way I can be sure that the table name will be unique for every user.
> Are there better ways of using temporary tables in FB ?

You could let all users use the same (permanent) table. Add a field -
SESSION_ID - to the table. Let each session retrieve a session_id from a
You will find posts on this in the archives.

Aage J.