Kbase P96524: 7579 error when trying to use pro_element to split up array fields in SQL Views
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/23/2010 |
|
Status: Verified
SYMPTOM(s):
Getting error 7579 when saving SQL View
View column list must be specified as expressions are given (7579)
View being used to split up an array field
Trying to use pro_element
SQL Looks like this: create view testview as select pro_element(monthQuota,1,1) from pub.salesrep
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
When using an expression for the arrayfield, an arrayfield list is needed
FIX:
Modify code as follows: create view testview (month1) as select pro_element(monthQuota,1,1) from pub.salesrep