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

Re: [Q] SQLMoreResults causes error in SQLFetchScroll

From: "V S P" <toreason(at)fastmail(dot)fm>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Date: 2009-05-18 05:16:41
Message-ID: 1242623801.9549.1315946739@webmail.messagingengine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi
thank you,

unfortunately there is no way to do that (as the OTL library
relies on RowCount  to be an independent function
and it cannot be mixed with other operations

(because then getting row count for Insert/Delete/Update would
require a completely different function flow then for selects)

So cannot even suggest OTL maintainer to implement this, as there
is no feasable way.

Is this an expected behavior (that is an ODBC spec recommends this)?


thank you,
Vlad


On Mon, 18 May 2009 12:27 +0900, "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
wrote:
> 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);
> 
> 
-- 
  V S P
  toreason(at)fastmail(dot)fm

-- 
http://www.fastmail.fm - Accessible with your email software
                          or over the web


In response to

pgsql-odbc by date

Next:From: Timothy MaddenDate: 2009-05-19 12:59:59
Subject: Re: How can I bind query parameters to variables ?
Previous:From: Hiroshi InoueDate: 2009-05-18 03:27:12
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll

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