Skip site navigation (1) Skip section navigation (2)

Re: [Q] SQLMoreResults causes error in SQLFetchScroll

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: V S P <toreason(at)fastmail(dot)fm>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Date: 2009-05-18 03:27:12
Message-ID: 4A10D590.3070902@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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);



In response to

Responses

pgsql-odbc by date

Next:From: V S PDate: 2009-05-18 05:16:41
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Previous:From: V S PDate: 2009-05-17 17:33:37
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group