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 JAA85297 for ; Mon, 8 Mar 1999 09:57:17 -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 JAA18258 for pgsql-interfaces@postgreSQL.org; Mon, 8 Mar 1999 09:35:57 -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 AA36195; Mon, 8 Mar 1999 09:18:53 -0500 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA32274; Mon, 8 Mar 1999 09:18:52 -0500 Message-Id: <36E3DE56.AE9FC94F@insightdist.com> Date: Mon, 08 Mar 1999 09:27:34 -0500 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Sergio Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] row count References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. Byron