Kbase P12504: Array Field display in SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Within 4GL are able to view the extents as separate fields - user-def 1 and this would define the first field only.
Via ODBC via Microsoft access user-def, defines in db as ten extents. usr-def 1 usr-def2 etc. ODBC appears as user-def all together as one field delimited by semi colons. In Progress this is delimited as user-def (1) etc. Access shows all information delimited.
Merant 3.60
SQL-92.
FIX:
By default, SQL-92 connections will display array fields as one semi-colon delimited field. There are two ways to get around this issue with array fields.
- Parse the delimited data of the array field in Actuate Basic and display it in the report
or
- Create a view with the data from the field.
The second option of creating a view would be the more efficient way of doing this because the processing takes place on the server rather than the client.