Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.2/8.9.1) with ESMTP id RAA44942
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 8 Mar 1999 17:33:13 -0500 (EST)
	(envelope-from byronn@insightdist.com)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id RAA25997
	for pgsql-interfaces@postgreSQL.org;
	Mon, 8 Mar 1999 17:06:02 -0500 (EST)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!byronn using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA34360; Mon, 8 Mar 1999 16:43:45 -0500
Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA26380; Mon, 8 Mar 1999 16:43:44 -0500
Message-Id: <36E44696.38F7C64B@insightdist.com>
Date: Mon, 08 Mar 1999 16:52:22 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Sergio <ser@perio.unlp.edu.ar>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] row count
References: <SAK.8.3.1999.ihoohjbi@speedy.perio.unlp.edu.ar>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit



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