OpenAccess for OpenEdge: extent fields (arrays) - Forum - DataDirect Connect - Progress Community

OpenAccess for OpenEdge: extent fields (arrays)

 Forum

OpenAccess for OpenEdge: extent fields (arrays)

This question is not answered
salesrep_pd.p

Hi all,

I have adopted the customer_pd sample data source for salesrep_pd, see attached file.

The salesrep table has an array field (monthquota). The Json data in the catalog file looks like this here:

"MonthQuota": {
"type": "array",
"maxItems": 12,
"items": {"type": "integer"},
"ablType": "INTEGER",
"default": 0
},

when opening the ODBC data source in Excel I am getting this error:

---------------------------
Database Error: 10300
---------------------------
[DataDirect][ODBC OpenAccess SDK driver][OpenEdge]JSONObject["title"] not found.[10300]
---------------------------
OK Abbrechen
---------------------------

When I remove the array field, everything works fine with the data source.

Are array fields supported with OpenAccess for OpenEdge?

Architect of the SmartComponent Library and WinKit

Consultingwerk Ltd.

All Replies