Error 199

"INSERT/DELETE on cursor can modify only one table"

Item Description

SQLCode

-199L

Constant

ONLY_ONE_TABLE

SQLState

09W04

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2130

Severity Code

15

Probable cause

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.


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