Multiple result sets and memory usage

[yeohray]

I have a query that returns 3 large result sets. I need to display all 3 result sets in 3 different grids. How can I do this, using the minumum amount of memory?

Currently, I am opening each result set, copying the data to a memory table, which then hooks up to a grid. This consumes a lot of memory at the beginning (2x the memory used by the 3 result sets).

Thanks.

Ray Mond

[Jackson]

SDAC doesn't support multiple active local result sets.
Use several TMSQuery components to avoid copying of data.