SQL Compatibility - Update statement with Subquery

Posted by netprw on 08-Sep-2011 03:28


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


work fine.


All Replies

This thread is closed