CoolBorg SQL.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Friday, August 23, 2013 4:29 AM
To: 'U2 Users List'
Subject: Re: [U2] SQL Update Multiple rows
Hi Riverman
That's
Hi Riverman
That's obviously TSQL and therefore Microsoft specific. You can get clever
in that way by mixing UniVerse SQL and EVAL expressions (which are the same
as inline IDescriptors in RetrieVe)
This should work the same as the example below:
UPDATE Product SET Availability = EVAL "IF Produ
As Kurt pointed out I should have used single quotes ('') instead of NULL.
NULL updated the field with char(128).
--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681p41685.html
Sent from the U2 - Users mailing list archive at Nabble
I had to change "" to NULL. The field has a format of 8R so I assume SQL is
interpreting this as a numeric field, not a string.
UPDATE TESTFILE SET TRAN.NUMBER=NULL WHERE CONTROL.NUMBER.NFMT='9001' OR
CONTROL.NUMBER.NFMT='66551' OR CONTROL.NUMBER.NFMT='1205'
--
View this message in context:
Dunces cap firmly attached to head.
For future reference can multiple rows be updated to different values for
the same field?
--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681p41683.html
Sent from the U2 - Users mailing list arch
UPDATE TESTFILE SET TRAN.NUMBER="" WHERE CONTROL.NUMBER.NFMT='9001' OR
CONTROL.NUMBER.NFMT='66551' OR CONTROL.NUMBER.NFMT='1205'
Should do what you want
George
Basically, only clear out TRAN.NUMBER if CONTROL.NUMBER.NFMT is one of three
values.
-Original Message-
From: u2-users-b