what is wrong with this sqlite3 statement

Question

Hi,

I have written this sqlite statement and I am getting syntax error:

update List SET number = (CASE WHEN number>=3 then number++ WHEN number=1 then 3 ELSE number END) WHERE listKey=3;

I keep on getting : SQL error: near "WHEN": syntax error

I tried various versions, adding braces at places and all, but can't figure out the error. Can anyone pls. help me with this.

Thanks in Advance, rs

Answer 1

If SQLite uses "++" syntax, I've never seen it. Try then number + 1 instead.