SQL adaptation guide for SQLite 3.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.