RB Smissaert 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
I am sure I have run this before with no trouble.
According to the web page, there should be only one WHERE clause, after
all the assignments.
UPDATE
sql-statement ::= UPDATE [ OR conflict-algorithm ] [database-name.]
table-name SET assignment [, assignment]*
[WHERE expr]
assignment ::= column-name = expr
HTH,
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------