 |
|
|
|
| | |
|
SQLRowCount
..msdn Add comment W32 Constants Translate this page |
|
|
|
SQLRowCount returns the number of rows affected by an UPDATE, INSERT, or DELETE statement. |
| | | Code examples: | | |
|
| | | Declaration: | | |
SQLRETURN SQLRowCount(
SQLHSTMT StmtHandle,
SQLINTEGER * RowCountPtr);
|
| | | | FoxPro declaration: | | |
DECLARE SHORT SQLRowCount IN odbc32;
INTEGER StmtHandle,;
INTEGER @ RowCountPtr
|
| | | | Parameters: | | StatementHandle
[Input]
Statement handle.
RowCountPtr
[Output]
Points to a buffer in which to return a row count. |
| | | Return value: | | | SQL_SUCCESS (0), SQL_SUCCESS_WITH_INFO (1), or error codes: SQL_ERROR, SQL_INVALID_HANDLE |
| | | My comment: | | When SQLRowCount returns SQL_ERROR or SQL_SUCCESS_WITH_INFO, an associated SQLSTATE value can be obtained by calling SQLGetDiagRec with a HandleType of SQL_HANDLE_STMT and a Handle of StatementHandle.
When SQLExecute, SQLExecDirect, SQLBulkOperations, SQLSetPos, or SQLMoreResults is called, the SQL_DIAG_ROW_COUNT field of the diagnostic data structure is set to the row count, and the row count is cached in an implementation-dependent way. |
| | | Translate this page: | | | | | | • | | | Created: | 2003-07-17 15:02:58 | | Modified: | 2003-07-17 15:06:18 |
Visited in last 7 days: 18 |
|
|
|
|
|
Copyright © 2001-2013
News2News, Inc.
Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use.
The information on this page is presented AS IS, meaning that you may use it at your own risk.
Microsoft Visual FoxPro
and Windows are trade marks
of Microsoft Corp.
All other trademarks are the property of their respective owners.
Privacy policy
|
|
|
|
Credits: PHP (4.4.9), an HTML-embedded scripting language,
MySQL (5.1.55-log), the Open Source standard SQL database,
AceHTML Freeware
Version 4, freeware HTML Editor of choice. Hosted by Korax Online Inc. |
|
|
|
|
|
|
|
How to obtain the number of rows affected by remote UPDATE, INSERT or DELETE statement