Core subroutine
Return the number of rows affected by an UPDATE, INSERT, or DELETE statement.
call EDSRowCount(HSTMT_IV, NUMROWS_IV )
•HSTMT_IV An input integer value that indicates the statement handle for the UPDATE, INSERT, or DELETE statement.
•NUMROWS_IV An output integer value indicating the number of rows affected by the operation.
Description
If the last executed statement associated with this statement handle was not an update, insert, or delete request, the value of NUMROWS_IV is driver-defined.
Return Value
EDSRowCount returns EDS_SUCCESS, EDS_ERROR, or EDS_INVALID_HANDLE.
When EDSRowCount returns EDS_ERROR, you can obtain an associated SQLSTATE value with more specific information by calling EDSError. The following table lists each typical SQLSTATE value and explains each one in the context of the command EDSRowCount.
The following table lists possible SQLSTATE values:
SQL STATE |
Error |
Description |
IM001 |
Driver does not does not support the function |
The driver associated with the statement handle support this. function |
S1000 |
General error |
An error occurred for which there was no specific SQLSTATE and for which no implementation-specific SQLSTATE was defined. The error message returned by EDSError in the argument ERRORTEXT describes the error and its cause. |
S1001 |
Memory allocation failure |
The driver was unable to allocate the memory required to support execution or completion of the function. |
S1010 |
Function |
The function was called prior to calling sequence error EDSExecute or EDSExecDirect for the statement handle. An asynchronously executing function (not this one) was called for the statement handle and was still executing when this function was called. |
See Also
EDSExecute and EDSExecDirect execute an UPDATE, INSERT, or DELETE statement.
