Information générale
Catégorie:
Codage, syntaxe et commandes
>If you return several recordsets (e.g. you have couple Select statements in called stored procedure) then you will get several recordsets with 'similar' names (w/out using additional functions like sqlmoreresults), i.e. if you request "sqlResult" and 3 recordsets returned, then you got sqlResult, sqlResult1, sqlResult2. All them opened so you can use USED() function in loop to determine how manu recordsets you really received.
How does SqlMoreResults have any influence on what the recordsets are named? There is no apparent way to use SQLMoreResults() in such a manner... no arguments for specifying a cursor name. All you can pass it is the connection handle. From VFP Help:
Syntax
SQLMORERESULTS(nConnectionHandle)
Returns
Numeric
Arguments
nConnectionHandle Specifies the connection handle to the data source returned by SQLCONNECT( ).
Précédent
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