I think Dynamic Views could help, but again u need to test performance
On 10/11/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi guys > > I have the need to develop a purchasing application that scans the last > months sales, compares estimated shipping times and onhand quantities to > generate purchacing recommendations (actually a good deal more complicated > than this, but thats the gist). The resulting file is presented to the > user > who examines it over a few days and takes action on it. Then, it gets > deleted. There is an undetermined number of files to be created > (depending > on how many people are doing purchasing at that time) all with the same > structure. > > This means that I'll have to create a few temporary tables to hold the > data > and then delete them after the work is finished. > > I have a similiar need for aging Accounts Receivable. > > What is the recommended way of creating temporary tables and then deleting > them when they are no longer needed? I know how to do this in SQL, just > not > in Ofbiz. > > Skip > >
