INSERT/DELETE on cursor can modify only one table
Item |
Value |
---|---|
SQLCode |
-199 |
Constant |
SQLE_ONLY_ONE_TABLE |
SQLState |
09W04 |
ODBC State |
42000 |
You have attempted to INSERT into a cursor and have specified values for more than one table; or you have tried to DELETE from a cursor that involves a join. INSERT into one table at a time. For DELETE, use the FROM clause to specify which table you wish to delete from.