Re: [Q] SQLMoreResults causes error in SQLFetchScroll

V S P wrote:
> Sorry forgot to mention the actual error I am getting:
>
> http://pastebin.com/d49e830c0
>
> SQLSTATE = HY010
> NATIVE ERROR = 0
> MSG = [Microsoft][ODBC Driver Manager] Function sequence error

Please do fetch operations for each result. For exmaple you
can do fetch operations at *// Do fetch operations here *
below.

regards,
Hiroshi Inoue

174./***********************************************************/
175./* PROBLEM:                                                */
176./* IF YOU COMMENT THE BELOW LOOP OUT  SQLFetchScroll works */
177./***********************************************************/
178.
179.        do
180.        {
181.          rc = SQLRowCount(hstmt, &rpc);
182.          if (rc!=SQL_SUCCESS)
183.          {
184.            break;
185.          }
186.          rowsum += rpc;

    // Do fetch operations here

187.          rc = SQLMoreResults(hstmt);
188.    } while (rc==SQL_SUCCESS);