| From: | "Malm Paul" <paul(dot)malm(at)saabgroup(dot)com> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | get number of rows selected |
| Date: | 2008-04-03 13:20:04 |
| Message-ID: | 9103513CAFE9554496DD17054510B6DF01287EA1@corpappl002.corp.saab.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi,
I dont know much about databases, and I have a question
I've just installed PostgreSLQ.
Now I would like to get the number of rows selected via a ODBC SQL
statement in C++. I would like to know the amount before I do Fetch.
This is a little example of what I do in c++:
selStr="select * from layer where visible = 1");
rc = SQLAllocHandle(SQL_HANDLE_STMT, ConHandle, &StmtHandle);
if(rc == SQL_SUCCESS)
{
SQLSetStmtOption(StmtHandle, SQL_CONCURRENCY,
SQL_CONCUR_READ_ONLY);
SQLSetStmtOption(StmtHandle, SQL_CURSOR_TYPE,
SQL_CURSOR_KEYSET_DRIVEN);
SQLSetStmtOption(StmtHandle, SQL_ROWSET_SIZE, m_rows);
rc = SQLExecDirect(StmtHandle, (SQLCHAR *)selStr,
SQL_NTS);
...
...
...
How do I know how many rows that was found??
Kind regards,
Paul Malm
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nguyen, Lam Thuy | 2008-04-03 14:04:05 | Connection of postgres |
| Previous Message | noreply | 2008-04-02 10:21:34 | [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0 |