Yes, thanks, I just found out.
It can work without the WHERE clauses.
RBS
-Original Message-
From: Gerry Snyder [mailto:[EMAIL PROTECTED]
Sent: 06 August 2007 21:59
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Multiple fields update
RB Smissaert wrote:
> I am sure this SQL u
RB Smissaert wrote:
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
Does the thread below ring a bell? Does it help?
Gerry
2 matches
Mail list logo