PRB: No Error If UPDATE or DELETE Processes 0 Rows

ID Number: Q63869

1.10 1.11 4.20

OS/2

Summary:

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.

Additional reference words: 1.10 1.11 4.20