iphone sqlite3 UPDATE with LIMIT and OFFSET clause
- by Remover
Does anyone know if the LIMIT and OFFSET clause work when using the UPDATE statement on iphone. on the sqlite3 website it says
"if SQLite is built with the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option then the syntax of the UPDATE statement is extended with optional ORDER BY and LIMIT clauses.."
if not, can it be enabled?
I'm using "UPDATE TESTDATA SET VAR = 1 LIMIT 1 OFFSET 1"
but i get an error: near "LIMIT": syntax error
I can get LIMIT and OFFSET clause to work on a SELECT statement.
Are there any other ways around this?