Error 734

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

Item Description

SQLCode

-734L

Constant

CANNOT_UPDATE_NULL_ROW

SQLState

09W08

ODBC 2 State

42000

ODBC 3 State

42000

Sybase Error Code

2379

Severity Code

16

Parameter 1

The name of the table that cannot be modified.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com