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 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 ---------------------------------------------------------------------------- ----------------------- Yes, thanks, that works indeed. RBS -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: 11 March 2007 02:55 To: SQLite Subject: [sqlite] Re: What is wrong with this UPDATE? RB Smissaert <[EMAIL PROTECTED]> wrote: > > UPDATE > > A3SQLADC_J > > SET > > ADDED_DATE = '' WHERE ADDED_DATE = 0 OR ADDED_DATE IS NULL, > > START_DATE = '' WHERE START_DATE = 0 OR START_DATE IS NULL > > > > near ",": syntax error > Make it UPDATE A3SQLADC_J SET ADDED_DATE = (case when ADDED_DATE = 0 OR ADDED_DATE IS NULL then '' else ADDED_DATE end), START_DATE = (case when START_DATE = 0 OR START_DATE IS NULL then '' else START_DATE end); Igor Tandetnik ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------