Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: get number of rows selected
- From: Andrei Kovalevski <andyk(at)commandprompt(dot)com>
- To: pgsql-odbc(at)postgresql(dot)org
- Cc: Adam M <gnuman1(at)gmail(dot)com>, Malm Paul <paul(dot)malm(at)saabgroup(dot)com>
- Subject: Re: get number of rows selected
- Date: Mon, 07 Apr 2008 04:30:16 +0300
- Message-id: <47F97928(dot)6010905(at)commandprompt(dot)com>
|
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/ |
- References:
- get number of rows selected
- From: Malm Paul
- Re: get number of rows selected
- From: Adam M
- get number of rows selected
- Prev by Date: Re: Connection of postgres
- Next by Date: Re: Connection of postgres
- Previous by thread: Re: get number of rows selected
- Next by thread: [ psqlodbc-Bugs-1010376 ] GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix
- Indexes: