Re: [INTERFACES] row count - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] row count
Date
Msg-id 36E44696.38F7C64B@insightdist.com
Whole thread Raw
In response to Re: [INTERFACES] row count  (Sergio <ser@perio.unlp.edu.ar>)
List pgsql-interfaces

Sergio wrote:

> Byron Nikolaidis <byronn@insightdist.com> el día Mon, 08 Mar 1999 09:27:34
> -0500, escribió:
>
> >
> >
> >Sergio wrote:
> >
> >> Byron,
> >>
> >> How I can know the number of rows in the set after a _select_
> >> (ie SQLRowCount isn't valid here) statement using ODBC ?
> >>
> >>
> >
> >Actually, it is valid, and will return the number of rows in the result
> >set, but only if you are *NOT* using the "Declare/Fetch" option of the
> >driver.
>
> Very good information, thanks.
>
> Now suppose that I don't know if the user is using declare/fetch,
> I have another option ?
>
>

SQLRowCount returns -1, which is what the odbc spec says to return if the
driver doesnt know the count.

Byron



pgsql-interfaces by date:

Previous
From: Michael Davis
Date:
Subject: RE: [INTERFACES] Re: Read-only in MSAccess
Next
From: jrl@msbit.com (Jim Lawson)
Date:
Subject: Re: Odd program behaviour