iphone sqlite3 UPDATE with LIMIT and OFFSET clause
Posted
by Remover
on Stack Overflow
See other posts from Stack Overflow
or by Remover
Published on 2010-03-25T21:48:12Z
Indexed on
2010/03/25
21:53 UTC
Read the original article
Hit count: 424
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?
© Stack Overflow or respective owner
