Kbase P21668: Is it possible to use Array fields with Progress ODBC SQL-92 Driver.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
Is it possible to use Array fields with Progress ODBC SQL-92 Driver.
GOAL:
Is it possible to use Extents fields with Progress ODBC SQL-92 Driver.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
To handle Array Fields you have to use the PRO_ELEMENT function.
This function extracts one or more elements from an array column and returns the NVARCHAR or VARCHAR string between the specified positions, including any internal separator characters and any internal escape characters.
SYNTAX
PRO_ELEMENT ( 'array_style_expression', start_position, end_position ) ;
array_style_expression
A string of datatype VARCHAR or CHAR, with a semi-colon ( ; ) separating each element of the array.
start_position
The position in the string marking the beginning of the element PRO_ELEMENT is to extract.
end_position
The position in the string marking the end of the element to be extracted.
Please see the documentation for more information.