Re: [INTERFACES] row count

Sergio wrote:

> Byron Nikolaidis <byronn(at)insightdist(dot)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