Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (D-K)

 

INSERT/DELETE on cursor can modify only one table

Error constant SQLE_ONLY_ONE_TABLE
ODBC 2 State 37000
ODBC 3 State 42000
Severity 15
SQLCODE –199
SQLSTATE 09W04
Sybase error code 102
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.