[sqlite] Multiple fields update

[RB Smissaert]

I am sure this SQL used to be fine with SQLite:

update table1
set
field1 = 0 where field1 = 2,
field2 = 3 where field2 = 2

Now however I get a syntax error near ,

Has this changed?


RBS




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------