Hello,
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 ON (default).
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
--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/