>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( ).