4D Doc Center : ODBC

Home

4D v14.1

ODBC_SQLRowCount


ODBC_SQLRowCount ( stmtID ; rowCount ) -> Function result

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 Reference at http://msdn.microsoft.com/en-us/library/ms711835(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Example

See the example for the ODBC_SQLBulkOperations command.