temporary workfiles (1 Viewer)

[Farah]

How do I generate a temporary table w/c is updatable?
I am running a command called "Generate Schedule" where user should enter a cut-off date. Based on this cut-off date, event skeds are generated (eg, 10 days before cut-off date, process X should be running, 5 days before process X, process Y should be running, etc).
This is for inquiry only and I don't need to save the information, that's why I need to create something temporary only
Help please!!!
Thanks.

 

[BillP]

I have done something similar for a financial application I had to build. You have to use the CREATE TABLE SQL command. Below is a copy of the SQL I used.

CREATE TABLE TempCashFlows ([Cash_Inflows] DOUBLE, [Cash_Outflows] DOUBLE,[Side_Acct_Balance] DOUBLE);

If you take this approach you will probably also have to write a routine to check if the tabledef exists, and remember to delete it when you are finished. Another alternative is to create your own data type, and put it in an array. I usually do that now instead of creating temporary tables. - Good Luck!