| Subject | Right way to get number of rows? |
|---|---|
| Author | Maury Markowitz |
| Post date | 2012-06-22T00:57:31Z |
I'm trying to retrive the number of rows from a query passed in via ODBC. Not much to it...
if (!SQL_SUCCEEDED(SQLRowCount(odbcStmt, (SQLLEN *)&rowCount))) {
rowCount = 0;
}
This works for most providers, but returns -1 on Firebird. Is there another call I should used instead?
if (!SQL_SUCCEEDED(SQLRowCount(odbcStmt, (SQLLEN *)&rowCount))) {
rowCount = 0;
}
This works for most providers, but returns -1 on Firebird. Is there another call I should used instead?