>Hi Cindy, Alex.
>
>Why not use a view for the temporary table & let VP handle the temporary table locations? Once defined, each user with have their own private table. Also, I prefer to have temporary tables on a special directory on the server, but with local hard drives being big anyway, it's not much of an issue anymore.
>
> Andy Crawshaw

Alex,

If the data does not have to persist after the session, I have done some cool things with views bizobjs. I have create a template table and a view with "send updates" option unchecked. The bizobj knows how to deal with it, but the data isn't saved. I've also created cursors in code in the post init hook method. all this depends on whether you need to save this info later. I don't recommend temp tables on the hard drive--too much room for error.