4D v13

ODBC_SQLRowCount

Home

 
4D v13
ODBC_SQLRowCount

ODBC_SQLRowCount 


 

ODBC_SQLRowCount ( stmtID ; rowCount ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
rowCount  Longint in Number of rows affected by the request
Function result  Longint in Returns the result of the MS ODBC API function SQLRowCount

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.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Example  

See the example for the ODBC_SQLBulkOperations command.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Results
Number: 16951

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLBulkOperations
ODBC_SQLSetPos