Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SP returns 2 results sets, how do I retrieve them in VFP
Message
De
19/02/2003 09:16:11
Bob Archer
Tampa, Floride, États-Unis
 
 
À
18/02/2003 18:10:51
Margaret Gillon
Chromalloy
Anaheim, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Re: SP returns 2 results sets, how do I retrieve them in VFP
Divers
Thread ID:
00754718
Message ID:
00754888
Vues:
18
This message has been marked as a message which has helped to the initial question of the thread.
>lcCommand = "exec ap_ShippingDetailForDateRange '1000', '2000'"
>=SQLSetProp(lnConnect, "BatchMode", .F.)
>lnResult = sqlexec(lnConnect, lcCommand, 'curOpen')

Since you are running with BatchMode = .f. you will have to call SQLMoreResults() to get the additional result set/cursor.

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform