Error 209

"Constraint '%1' violated: Invalid value for column '%2' in table '%3'"

Item Description

SQLCode

-209L

Constant

INVALID_COLUMN_VALUE

SQLState

23506

ODBC 2 State

42000

ODBC 3 State

23000

Sybase Error Code

2131

Severity Code

16

Parameter 1

Name of the constraint (if defined) that was violated by an invalid value.

Parameter 2

Name of the column that was assigned an invalid value.

Parameter 3

Name of the table containing the column.

Probable cause

You attempted an insert or update that violates a CHECK constraint. A CHECK constraint is violated if it evaluates to FALSE; it is deemed to hold if the condition evaluates to TRUE or UNKNOWN.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com