Re: [U2] SQL Update Multiple rows

2013-08-23 Thread George Gallen
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

Re: [U2] SQL Update Multiple rows

2013-08-23 Thread Brian Leach
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

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread Riverman
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

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread Riverman
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:

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread Riverman
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

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread George Gallen
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