Hello,
Been trying to carry out some SQL updates onto a Progress 9.1E databasse via the SQL92 ODBC driver and can not get update statements to complete when usign a subquery, ie :
update pub.ORDERS t1
set PROD_DESC = (Select DESC from pub.PRODUCT t1 where t1.PROD_CODE = t2.PROD_CODE)
Is such an update epossible in Progress SQL ? If not are their any acknowledged SQL work arounds (cursors ??) to accomodate this type of operation?
Single Value updates such as :
update pub.ORDERS t1
set PROD_DESC = 'FRED'
work fine.
Thanks