Messages on this page are sorted by Sybase error code. Locate the appropriate code in the table below, and click the link for a full description of the message.
Number | Msg Type | SQL State | SQL Code | Message | Possible Cause |
---|---|---|---|---|---|
2127 | Error | 23505 | -196L | "Index '%1' for table '%2' would not be unique" | You attempted to insert or update a row that has the same value as another row in some column, and there is a constraint that does not allow two rows to have the same value in that column. Click here for a list of possible parameters and odbc states. |
2128 | Error | 24503 | -197L | "No current row of cursor" | You attempted to perform an operation on the current row of a cursor, but the cursor is not positioned on a row. The cursor is before the first row of the cursor, after the last row, or is on a row that has since been deleted. Click here for a list of possible parameters and odbc states. |
2129 | Error | 23W05 | -198L | "Primary key for row in table '%1' is referenced by foreign key '%2' in table '%3'" | You attempted to delete or modify a row whose primary key value is referenced elsewhere in the database. Click here for a list of possible parameters and odbc states. |
2130 | Error | 09W04 | -199L | "INSERT/DELETE on cursor can modify only one table" | You attempted to insert into a cursor and have specified values for more than one table, or you attempted to delete from a cursor that involves a join. Insert into one table at a time. For DELETE, use the FROM clause to specify the table you want to delete from. Click here for a list of possible parameters and odbc states. |
2131 | Error | 23506 | -209L | "Constraint '%1' violated: Invalid value for column '%2' in table '%3'" | 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. Click here for a list of possible parameters and odbc states. |
2132 | Error | 22W02 | -208L | "Row has changed since last read -- operation canceled" | You attempted an UPDATE (positioned) or DELETE (positioned) operation on a cursor declared as a SCROLL cursor, and the row you are changing has been updated since you read it. This error prevents the "lost update" problem. Click here for a list of possible parameters and odbc states. |
2133 | Error | 53002 | -207L | "Wrong number of values for INSERT" | The number of values you are trying to insert does not match the number of columns specified in the INSERT statement, or the number of columns in the table if no columns are specified. Click here for a list of possible parameters and odbc states. |
2139 | Error | 42W14 | -260L | "Variable '%1' not found" | You attempted to DROP or SET the value of a SQL variable that was not created or was previously dropped. Click here for a list of possible parameters and odbc states. |
2140 | Error | 42W15 | -261L | "There is already a variable named '%1'" | You attempted to create a variable with the name of another variable that already exists. Click here for a list of possible parameters and odbc states. |
2141 | Error | 42W24 | -262L | "Label '%1' not found" | You reference a label in a LEAVE statement, but the label could not be found. Click here for a list of possible parameters and odbc states. |
2142 | Error | 42W25 | -263L | "Invalid absolute or relative offset in FETCH" | You specified an offset in a FETCH that was invalid or NULL. Click here for a list of possible parameters and odbc states. |
2143 | Error | 42W26 | -264L | "Wrong number of variables in FETCH" | You specified a number of variables in a FETCH statement that does not match the number of select list items. Click here for a list of possible parameters and odbc states. |
2144 | Error | 52W09 | -265L | "Procedure '%1' not found" | You misspelled the name of a procedure, or you did not qualify a procedure name with a user name. Click here for a list of possible parameters and odbc states. |
2146 | Error | 42W28 | -267L | "COMMIT/ROLLBACK not allowed within atomic operation" | You attempted a COMMIT or ROLLBACK statement while executing within an atomic operation. Click here for a list of possible parameters and odbc states. |
2147 | Error | 52W10 | -268L | "Trigger '%1' not found" | You misspelled the name of a trigger, or you did not qualify a trigger name with a user name. Click here for a list of possible parameters and odbc states. |
2148 | Error | 53W06 | -269L | "Cannot delete or rename a column referenced in a trigger definition" | You attempted to delete or rename a column referenced in a trigger definition. Drop the trigger before performing the ALTER statement. Click here for a list of possible parameters and odbc states. |
2149 | Error | 55W04 | -270L | "Cannot drop a user that owns procedures in runtime server" | You attempted to drop a user that owns procedures while using the runtime server. This operation would result in dropping procedures. The runtime server cannot drop procedures. Use the full server. Click here for a list of possible parameters and odbc states. |
2150 | Error | 52W11 | -271L | "Trigger definition conflicts with existing triggers" | You attempted to create a trigger, but a trigger with the same name already exists. Click here for a list of possible parameters and odbc states. |
2151 | Error | 52W12 | -272L | "Invalid REFERENCES clause in trigger definition" | You supplied an invalid REFERENCES clause in a trigger definition. You may have specified an OLD correlation name in a BEFORE INSERT trigger, or a NEW correlation name in an AFTER DELETE trigger. In both cases, the values do not exist and cannot be referenced. Click here for a list of possible parameters and odbc states. |
2152 | Error | 2D501 | -273L | "COMMIT/ROLLBACK not allowed within trigger actions" | You attempted to execute a statement that is not allowed while performing a trigger action. COMMIT and ROLLBACK statements cannot be executed from a trigger. Click here for a list of possible parameters and odbc states. |