Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

Cannot update or delete an all-NULL row from table '%1'

Error constant SQLE_CANNOT_UPDATE_NULL_ROW
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 The name of the table that cannot be modified.
Severity 16
SQLCODE –734
SQLSTATE 09W08
Sybase error code 13750
Probable cause

You attempted to modify or delete a row in the specified table, which is part of the NULL-supplying side of an outer join. However, the cursor is currently positioned on a derived row that contains an all-NULL row for this table, which is the result of the failure of one or more ON conditions to evaluate to TRUE. Verify that the UPDATE or DELETE statement is correct.