Kbase P99104: UPDATE statement fails with error 7529 when using a query expression to update a column.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/30/2008 |
|
Status: Verified
SYMPTOM(s):
UPDATE statement fails with error 7529 when using a query expression to update a column.
Subquery returns multiple rows (7529)
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
This is expected behavior. The query expression returns more than 1 row.
FIX:
As stated in the SQL-92 Guide and Reference: "If a query expression is specified on the right hand side of an assignment, the query expression must return one row."