Subject Re: [firebird-support] How to handle temporary tables
Author Nick Upson
In article <LDEAIABPMJJODAJOMONAOEDPDJAA.planles@...>, Planles wrote:
> So my question is, what is normal procedure to handle more temp table's ?
> Should my program create new table each time an user want to print and after
> that automaticaly delete it ?
> Or is there any other way suggested ?

Have one table that is not dropped but add a column to store the users id,
then include the userid in any query of the table and the delete of rows
at the end of processing

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly