Re: [Q] SQLMoreResults causes error in SQLFetchScroll - Mailing list pgsql-odbc

From Christophe Garault
Subject Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Date
Msg-id 4A103306.5070208@garault.org
Whole thread Raw
In response to Re: [Q] SQLMoreResults causes error in SQLFetchScroll  ("V S P" <toreason@fastmail.fm>)
Responses Re: [Q] SQLMoreResults causes error in SQLFetchScroll
List pgsql-odbc
Hi Vlad,

V S P wrote :
> Therefore I am pretty certain that it is SQLMoreResults and
> not SQLRowCount that cause a problem for pgODBC.
>
Sorry I didn't pay enough attention to your code this morning.
And yes SQLMoreResults could be the cause of your problem: this function
is supposed to move to the next resultset !
So calling SQLFetchScroll after SQLMoreResults when having only one
resultset is not a good idea. Btw I'm not sure of what your code is
supposed to do...
Have a look at Ms's site if you want more information:
http://msdn.microsoft.com/en-us/library/ms714673(VS.85).aspx

> But going back to your question, SQLFetchScroll will error out
> if you do not use select (because it is typically Select that returns
> result rows).
Sure, I thought you were only interested in SQLRowCount.
A lack of caffeine on Sunday morning causes apologies. ;)

--
Christophe Garault

Attachment

pgsql-odbc by date:

Previous
From: "V S P"
Date:
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll
Next
From: "V S P"
Date:
Subject: Re: [Q] SQLMoreResults causes error in SQLFetchScroll