OpenAccess for OpenEdge: extent fields (arrays)

Posted by Mike Fechner on 28-Oct-2014 16:38

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?

DataDirect Connect - Forum

All Replies

Posted by Brahmananda Gouni on 28-Oct-2014 23:36

Hi Mike,

In the current release we don't have support for extent (array) fields.

Currently we have support only for below ABL data types.

BLOB, Character, CLOB, Date, DateTime, DataTime – TZ, Decimal, Integer, Int64, Logical and  Raw.

Please refer the user guide for more details.

Thanks

Brahma

Posted by Mike Fechner on 29-Oct-2014 01:14

Hi Brahmananda,
 
Is the support for the array fields on the roadmap and planned for a future release?
 
If so, when?
 
Regards,
Mike
 
Von: Brahmananda Gouni [mailto:bounce-bgouni@community.progress.com]
Gesendet: Mittwoch, 29. Oktober 2014 05:36
An: TU.DD.Connect@community.progress.com
Betreff: RE: [Technical Users - DataDirect Connect] OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Brahmananda Gouni

Hi Mike,

In the current release we don't have support for extent (array) fields.

Currently we have support only for below ABL data types.

BLOB, Character, CLOB, Date, DateTime, DataTime – TZ, Decimal, Integer, Int64, Logical and  Raw.

Please refer the user guide for more details.

Thanks

Brahma

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Posted by Chandra Sekhar on 29-Oct-2014 01:45

Hi Mike,
 
We will support these features in next release. Dates are not finalized, I will keep you posted.
 
Thanks and Regards,
Chandu
 
 
[collapse]
From: Mike Fechner [mailto:bounce-mikefechner@community.progress.com]
Sent: 29 October 2014 AM 11:46
To: TU.DD.Connect@community.progress.com
Subject: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Mike Fechner
Hi Brahmananda,
 
Is the support for the array fields on the roadmap and planned for a future release?
 
If so, when?
 
Regards,
Mike
 
Von: Brahmananda Gouni [mailto:bounce-bgouni@community.progress.com]
Gesendet: Mittwoch, 29. Oktober 2014 05:36
An: TU.DD.Connect@community.progress.com
Betreff: RE: [Technical Users - DataDirect Connect] OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Brahmananda Gouni

Hi Mike,

In the current release we don't have support for extent (array) fields.

Currently we have support only for below ABL data types.

BLOB, Character, CLOB, Date, DateTime, DataTime – TZ, Decimal, Integer, Int64, Logical and  Raw.

Please refer the user guide for more details.

Thanks

Brahma

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Mike Fechner on 29-Oct-2014 01:52

Thanks!
Von: Chandra Sekhar [mailto:bounce-csekhar@community.progress.com]
Gesendet: Mittwoch, 29. Oktober 2014 07:46
An: TU.DD.Connect@community.progress.com
Betreff: RE: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Chandra Sekhar
Hi Mike,
 
We will support these features in next release. Dates are not finalized, I will keep you posted.
 
Thanks and Regards,
Chandu
 
 
[collapse]
From: Mike Fechner [mailto:bounce-mikefechner@community.progress.com]
Sent: 29 October 2014 AM 11:46
To: TU.DD.Connect@community.progress.com
Subject: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Mike Fechner
Hi Brahmananda,
 
Is the support for the array fields on the roadmap and planned for a future release?
 
If so, when?
 
Regards,
Mike
 
 
Von: Brahmananda Gouni [mailto:bounce-bgouni@community.progress.com]
Gesendet: Mittwoch, 29. Oktober 2014 05:36
An: TU.DD.Connect@community.progress.com
Betreff: RE: [Technical Users - DataDirect Connect] OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Brahmananda Gouni

Hi Mike,

In the current release we don't have support for extent (array) fields.

Currently we have support only for below ABL data types.

BLOB, Character, CLOB, Date, DateTime, DataTime – TZ, Decimal, Integer, Int64, Logical and  Raw.

Please refer the user guide for more details.

Thanks

Brahma

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by bwright on 29-Oct-2014 13:15

Hi Mike,

I'm the product manager for OpenAccess. I'm in London next week speaking at a conference (Thur morning) and would like to suggest a call. I'd like to better understand what you're working on (understand that you'll be presenting something to the European PUG) and what additional needs you've identified. Thanks.

Brad

[collapse]
From: Mike Fechner <bounce-mikefechner@community.progress.com>
Reply-To: "TU.DD.Connect@community.progress.com" <TU.DD.Connect@community.progress.com>
Date: Wednesday, October 29, 2014 1:53 AM
To: "TU.DD.Connect@community.progress.com" <TU.DD.Connect@community.progress.com>
Subject: [Technical Users - DataDirect Connect] AW: AW: OpenAccess for OpenEdge: extent fields (arrays)

Reply by Mike Fechner
Thanks!
Von: Chandra Sekhar [mailto:bounce-csekhar@community.progress.com]
Gesendet: Mittwoch, 29. Oktober 2014 07:46
An: TU.DD.Connect@community.progress.com
Betreff: RE: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Chandra Sekhar
Hi Mike,
 
We will support these features in next release. Dates are not finalized, I will keep you posted.
 
Thanks and Regards,
Chandu
 
 
[collapse]
From: Mike Fechner [mailto:bounce-mikefechner@community.progress.com]
Sent: 29 October 2014 AM 11:46
To: TU.DD.Connect@community.progress.com
Subject: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Mike Fechner
Hi Brahmananda,
 
Is the support for the array fields on the roadmap and planned for a future release?
 
If so, when?
 
Regards,
Mike
 
 
Von: Brahmananda Gouni [mailto:bounce-bgouni@community.progress.com]
Gesendet: Mittwoch, 29. Oktober 2014 05:36
An: TU.DD.Connect@community.progress.com
Betreff: RE: [Technical Users - DataDirect Connect] OpenAccess for OpenEdge: extent fields (arrays)
 
Reply by Brahmananda Gouni

Hi Mike,

In the current release we don't have support for extent (array) fields.

Currently we have support only for below ABL data types.

BLOB, Character, CLOB, Date, DateTime, DataTime – TZ, Decimal, Integer, Int64, Logical and  Raw.

Please refer the user guide for more details.

Thanks

Brahma

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse][/collapse]

This thread is closed