datawindow retrieve options

[kgillispie]

I need to retrieve a datawindow multiple times but keep results from all previous 'retrieves'.

In other words, I need a large result set in 1 datawindow that are compiled my multiple retrieves.

Thanks for the help.
kgillispie

 

[thekl0wn]

If you're doing a SQL SELECT, then why not use UNION's?

 

[mbalent]

I would create two datawindows, one for the retrieves and one for the storage. Once the data is retrieved you can do a rowcopy (there are many other ways to do this too) from the retieval dw to the storage dw.

Matt

"Nature forges everything on the anvil of time

 

[thekl0wn]

Expanding on mbalent's method, you can also achieve this using a DataWindow and a DataStore, for a bit better performance.