Take a look at SQLRowCount(
http://msdn2.microsoft.com/en-us/library//ms711835.aspx ). You may note:
*/For other statements and functions, the driver may define the value
returned in *RowCountPtr. For example, some data sources may be able to
return the number of rows returned by a SELECT statement or a catalog
function before fetching the rows./*
You may rely on this when using psqlODBC or ODBCng with buffering mode
Adam M wrote:
> Generally you would do that with a count function instead of relying
> on something else.
> "select * from layer where visible = 1"
> so I guess "SELECT COUNT(*) FROM layer WHERE visible=1" would give you
> the answer.
> - Adam
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
In response to
pgsql-odbc by date
|Next:||From: Andrei Kovalevski||Date: 2008-04-07 01:35:57|
|Subject: Re: Connection of postgres|
|Previous:||From: noreply||Date: 2008-04-03 17:20:30|
|Subject: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0|