Search results

Appreciate that, but is theior any other way then in Openedge SQL to do the update a different way ? ie, some form of "outer loop cursor" that then fires individual update statements inside the loop ? thanks

Its Openedge 9.1E. Need to understand if any "workarounds" are possible if teh subquery select for the update is indeed not possible (ie, a cursor perhaps doing single updates within the main loop ??) thanks

Hello, New to progress but understand that cant use a subquery in SQL ref an update statement. What I am trying to do is : UPDATE pub.sales t1 set t1.DESC = (select t2.DESC from pub.product t2 where t2.PRODUCTCODE = t1.PRODUCTCODE ) ie, Look up a value from a related table to update the...