PRB: No Error If UPDATE or DELETE Processes 0 Rows (63869)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q63869 SYMPTOMS
SQL Server does not report an error when an UPDATE or DELETE
statement fails to process any rows.
CAUSE
In SQL Server, an UPDATE or DELETE statement that does not process
any rows because of the conditions in the WHERE clause is
considered to have executed as intended. The status returned by
dbsqlexec() will be SUCCEED, not FAIL. DBCOUNT can be used to
determine the number of rows processed by the previous statement.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbProgramming KB63869 |
|---|
|