Here is the SQL example I am trying to follow
UPDATE dbo.Product
SET Availability=CASE When ProductId='1' Then '5'
When ProductId='2' Then '5'
When ProductId='6' Then '10'
Else Availability
END
My attempts
>UPDATE TESTFILE SET TRAN.NUMBER=CASE WHEN CONTROL.NUMBER.NFMT='9001' THEN
'' WHEN CONTROL.NUMBER.NFMT='66551' THEN '' WHEN CONTROL.NUMBER.NFMT='1205'
THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: A WHEN clause must have at least one multi-valued column
>UPDATE TESTFILE SET TRAN.NUMBER=CASE WHERE CONTROL.NUMBER.NFMT='9001' THEN
'' WHERE CONTROL.NUMBER.NFMT='66551' THEN '' WHERE
CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: syntax error. Unexpected symbol. Token was "THEN".
Scanned command was UPDATE RECEIPT SET TRANSACTION.H = CASE WHERE
CONTROL.NUMBER.NFMT = "900166550841" THEN
Universe 10.1.1, Windows Server 2003
--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
