UPDATE/DELETE … WHERE CURRENT OF

Informix®

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.

SQLite

SQLite does not support the SELECT ... FOR UPDATE and UPDATE/DELETE WHERE CURRENT OF SQL instruction.

Solution

Review the program logic and use primary keys to update the rows.