Thanks anyway Cindy. :)

Does anyone out there know if there is some combination of asynchronous, batch mode on/off and SQLMoreResults that will let me break apart the query and come back with manageable chunks at a time?

Any help would be much appreciated.

-- Chris

PS: Maybe this could be a great feature for the Fox Team to look into if it is not. Or the ability to put a cursor on it's own thread... perhaps like what SQL Server does.

>-------------------------------------
>-- Original message
>-------------------------------------
>>>>>Hi everyone.
>>>>>
>>>>>I have come across a situation where I need to background fetch a large result set (1.2 million records or more) from SQL Server...
>>>>>
>>>>>Is there some combination of asynchronous, batch mode on/off and SQLMoreResults that will let me break apart the query and come back with manageable chunks at a time?
>>>>>
>>>>>Thanks for your help.
>>>>>-- Chris