Subject | How to handle temporary tables |
---|---|
Author | Planles |
Post date | 2005-03-20T09:56:21Z |
Hello,
I have data stored in FB 1.5.2 in different tables.
I need some calculations with data from these tables, fill one temp. table
which I send to reporter tool to make a print out.
At the moment I have only one table, which I use to store these calculated
data, which is fixed created.
If more users make their print outs at the same time, each of user needs its
own temp. table, right ?
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 ?
Regards,
Primoz
I have data stored in FB 1.5.2 in different tables.
I need some calculations with data from these tables, fill one temp. table
which I send to reporter tool to make a print out.
At the moment I have only one table, which I use to store these calculated
data, which is fixed created.
If more users make their print outs at the same time, each of user needs its
own temp. table, right ?
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 ?
Regards,
Primoz