Hi Cindy,

The cursor/template idea is good. I think I'll go in that direction rather than "create table mytable free yada yada yada".

And the data doesn't need to persist at all. Once the user hits OK and the payments application is committed, we don't need the temp table anymore.

Alex


>Alex,
>
>So the data needs to be "private" for each user, but you did not say that it needs to persisit beyond a particular session. Why would a cursor (based on a "template" table which is stored on the network) not be suitable?
>
>You wouldn't ever have to be sure that the table was there or that it was zapped after the last use.
>
>
>>Hi Cindy,
>>
>>I'll quench your curiosity... It's for the invoicing part of the app I'm working on.
>>
>>My client sends out invoices and receives payments. Sometimes, one payment covers several invoices, sometimes a partial payment is to be applied PROPORTIONALLY to several invoices.
>>
>>For example, if we have two invoices, for $45 and $90 and we receive a payment of $60, $20 go to the first invoice, and $40 to the second.
>>
>>To make things REAL interesting, the user should be able to see all these invoices in a grid (like quickbooks), and over-ride the way the payments are applied (again, like quickbooks).
>>
>>Since I haven't been able to find a way to base a grid on an array or some ephimere structure, I decided that a temporary table should do.
>>
>>Now, why on the local harddrive? Because that takes care of segmenting the application. If several people want to enter payments at the same time, I don't have to worry about the logic to keep each user's temporary data separate from the other because it's kept in completely separate places.
>>
>>So far, things seem to be working. I managed to figure out where in the business object to stick the logic to create the temporary table. Now all I have left is writing the rest of the logic for the form to work as it's supposed.
>>
>>Kinda like: how do you sculpt an elephant? Well, you take a huge block of marble and you remove everything that doesn't look like one...
>>
>>Thanks for asking!
>>
>>Alex