have you looked thru the manufacturing module? you can always define and entity for your data then clear it out when finished.
[EMAIL PROTECTED] sent the following on 10/10/2007 8:32 PM: > 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 > > > >
