ODBC_SQLRowCount

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLRowCount (stmtID; rowCount) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
rowCountLongintNumber of rows affected by the request
Function resultLongintReturns 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.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next