Sybase Adaptive Server Anywhere - Page 769

CHAPTER 10 Database Error Messages
751
Cannot update or delete an all-NULL row from table ’%1’
Item Value
SQLCODE -734
Constant SQLE_CANNOT_UPDATE_NULL_ROW
SQLSTATE 09W08
Sybase error code 13750
ODBC 2 State 42000
ODBC 3 State 42000
Parameter 1 The name of the table which cannot be modified.
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.
Cannot update primary key for table ’%1’ involved in replication
Item Value
SQLCODE -781
Constant SQLE_REPL_ARTICLE_PK_CANNOT_BE_UPDATE
D
SQLSTATE 5RW20
Sybase error code 13791
ODBC 2 State 42000
ODBC 3 State 42S02
Parameter 1 Name of the table.
The primary key of a table involved in replication cannot be updated. The
database option "Allow_replication_pkey_update" can be set to "ON" to
allow updates to the primary key of table involved in replication.
Probable cause
Probable cause