pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedrow count
4+ messages / 2 participants
[nested] [flat]
* row count
@ 1999-03-05 09:31 Sergio <ser@perio.unlp.edu.ar>
1999-03-08 14:27 ` Re: [INTERFACES] row count Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sergio @ 1999-03-05 09:31 UTC (permalink / raw)
To: pgsql-interfaces
Byron,
How I can know the number of rows in the set after a _select_
(ie SQLRowCount isn't valid here) statement using ODBC ?
TIA,
Sergio
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] row count
1999-03-05 09:31 row count Sergio <ser@perio.unlp.edu.ar>
@ 1999-03-08 14:27 ` Byron Nikolaidis <byronn@insightdist.com>
1999-03-08 21:46 ` Re: [INTERFACES] row count Sergio <ser@perio.unlp.edu.ar>
0 siblings, 1 reply; 4+ messages in thread
From: Byron Nikolaidis @ 1999-03-08 14:27 UTC (permalink / raw)
To: Sergio <ser@perio.unlp.edu.ar>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] row count
1999-03-05 09:31 row count Sergio <ser@perio.unlp.edu.ar>
1999-03-08 14:27 ` Re: [INTERFACES] row count Byron Nikolaidis <byronn@insightdist.com>
@ 1999-03-08 21:46 ` Sergio <ser@perio.unlp.edu.ar>
1999-03-08 21:52 ` Re: [INTERFACES] row count Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sergio @ 1999-03-08 21:46 UTC (permalink / raw)
To: pgsql-interfaces
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 ?
Sergio
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] row count
1999-03-05 09:31 row count Sergio <ser@perio.unlp.edu.ar>
1999-03-08 14:27 ` Re: [INTERFACES] row count Byron Nikolaidis <byronn@insightdist.com>
1999-03-08 21:46 ` Re: [INTERFACES] row count Sergio <ser@perio.unlp.edu.ar>
@ 1999-03-08 21:52 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 4+ messages in thread
From: Byron Nikolaidis @ 1999-03-08 21:52 UTC (permalink / raw)
To: Sergio <ser@perio.unlp.edu.ar>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-03-08 21:52 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-05 09:31 row count Sergio <ser@perio.unlp.edu.ar>
1999-03-08 14:27 ` Byron Nikolaidis <byronn@insightdist.com>
1999-03-08 21:46 ` Sergio <ser@perio.unlp.edu.ar>
1999-03-08 21:52 ` Byron Nikolaidis <byronn@insightdist.com>
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