version 2004
ODBC_SQLRowCount (stmtID; rowCount) Longint
| Parameter | Type | Description | |
| stmtID | Longint | Statement ID | |
| rowCount | Longint | Number of rows affected by the request | |
| Function result | Longint | Returns the result of the MS ODBC API function | |
| SQLRowCount |
Description
The ODBC_SQLRowCount command returns the number of rows affected by an UPDATE, INSERT, or DELETE statement; an SQL_ADD, SQL_UPDATE_BY_BOOKMARK, or SQL_DELETE_BY_BOOKMARK operation in ODBC_SQLBulkOperations; or an SQL_UPDATE or SQL_DELETE operation in ODBC_SQLSetPos.
stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.
rowCount is the number of rows affected by the result set.
For more information, please see the SQLRowCount function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlrowcount.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
Example
See the example for the ODBC_SQLBulkOperations command.
See Also
ODBC_SQLBulkOperations, ODBC_SQLSetPos.