SQL adaptation guide For SQLite 3.5.x, 3.6.x / BDL programming |
Informix® allows positioned UPDATEs and DELETEs with the "WHERE CURRENT OF cursor" clause, if the cursor has been DECLARED with a SELECT ... FOR UPDATE statement.
SELECT ... FOR UPDATE is not supported by SQLite.
Review the program logic and use primary keys to update the rows.