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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only