Dear Sergey:
Yes, you are right. SQL returns the cursor names in proper order. The data area it opens them is variable depending on how SQL returns the cursors.
Regards,
Jim
>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
>>>>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement