Information générale
Titre:
SP returns 2 results sets, how do I retrieve them in VFP
I have written an SQL Stored Procedure that creates two result sets and I need them both in VFP. This is not the same as sending two select commands from VFP as shown in VFP help. I can't union the results because they have completely different structures and I need to keep those structures intact when I pull the data to VFP. They must be created together because the second set uses key values from the first set to retrieve additional data. Is there any way to retrieve both the cursors in VFP? At this time I get neither cursor and the data session window is empty.
lcCommand = "exec ap_ShippingDetailForDateRange '1000', '2000'"
=SQLSetProp(lnConnect, "BatchMode", .F.)
lnResult = sqlexec(lnConnect, lcCommand, 'curOpen')
Suivant
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