I believe that cursors're returned in the order queries were submited. I see no reason for VFP to change that order.
>Dear Sergey:
>
>Yes, I agree. Could you look at my response to Claudio about the way SQL returns the cursors.
>
>Thanks for the help,
>
>Jim Smith
>>You can use USE ... AGAIN command to reopen cursors with the names you want.
>>
>>>Thanks Mark,
>>>
>>>Yes, the naming of the 3rd parameter certainly gives an interesting result. If you leave it blank you get the result cursor named SQLResult, SQLResult1, .... SQLResultn. But, this seems to be problematic because SQL server may or may not return the cursor in the same order of the calling procedure order.
>>>
>>>This seems like a great feature that saves connecting and executing multiple SQLEXECs to retreive multiple record sets. I guess I am not sure how to resolve the issue of the returned cursors' naming convention.
>>>
>>>Regards and thanks,
>>>
>>>Jim Smith
>>>
--sb--