From: Byron Nikolaidis <byronn@insightdist.com>
To: Sergio <ser@perio.unlp.edu.ar>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] row count
Date: Mon, 08 Mar 1999 16:52:22 -0500
Message-ID: <36E44696.38F7C64B@insightdist.com> (raw)
References: <SAK.8.3.1999.ihoohjbi@speedy.perio.unlp.edu.ar>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, ser@perio.unlp.edu.ar
Subject: Re: [INTERFACES] row count
In-Reply-To: <36E44696.38F7C64B@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox