Kbase P113328: How to get elements of an extent field with Corvu ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/8/2006 |
|
Status: Unverified
GOAL:
How to get elements of an extent field with Corvu ?
GOAL:
How to get elements of an array with Corvu ?
FACT(s) (Environment):
CorVu
Progress 9.x
OpenEdge 10.x
FIX:
When using the SQL92 to query the Progress database using Corvu if elements of an extent field (array) are needed in a report or used for some Corvu calculation the best way to do this is create a virtual column using the PRO_ELEMENT function of the SQL92.
This virtual column can be defined as a numeric constant and in the value we can specify the values as : PRO_ELEMENT(<extentfield>,1,1), if math operations are to be performed with this field make sure to override the format of the virtual column to be an integer or a real number otherwise Corvu will see this field as a character string.