>Could somebody please translate this for me [taken directly from Help under SQLExec()]?
>
>If the SQL statement generates one result set, SQLEXEC( ) stores the result set to the specified Visual FoxPro cursor. If the SQL statement generates two or more result sets and SQLSETPROP( ) is set to 1 (batch mode), you can name each result set by setting the SQLSETPROP( ) BatchMode option to 0 and changing the cursor name each time you call SQLMORERESULTS( ).
>
>My questions:
>
>1. Did the people writing the documentation for the SQLxxxx() functions of VFP know what they were writing about. (I can already answer this one: NO!).
>2. "...SQLSETPROP( ) is set to 1..." -- There is no way to set SQLSETPROP() to 1. As written, this has no meaning. What DO they mean here?
>3. "... changing the cursor name each time you call SQLMORERESULTS( )" -- There is no way to change or even specify a cursor name when calling SQLMORERESULTS(). What do they mean here?
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.
Edward Pikman
Independent Consultant