JSDO catalog generated with characters that are invalid for JavaScript

A JSDO catalog generated from a schema include file in Progress Developer Studio contains dataset, table and/or field names exactly as they are defined in ABL, except that the SERIALIZE-NAME attribute is used instead of the name if it is available. If a character used in one of the names is valid in ABL but not valid in JavaScript, problems may occur on the client side when the catalog is used. Invalid characters are most commonly the hyphen or dash ("-") character. Common client-side problems include display problems and hyphens in names being interpreted as minus signs.

Feb 22, 2017
Knowledge

Title

URL Name

JSDO-catalog-generated-with-characters-that-are-invalid-for-JavaScript

Article Number

000176391

Environment

Product: OpenEdge Version: 11.2 and later OS: Windows Other: JSDO, JavaScript

Question/Problem Description

JSDO catalog generated with characters that are invalid for JavaScript

A JSDO catalog generated from a database table or schema include file in Progress Developer Studio contains dataset, table and/or field names exactly as they are defined in ABL, except that the SERIALIZE-NAME attribute is used instead of the name if it is available. If a character used in one of the names is valid in ABL but not valid in JavaScript, problems may occur on the client side when the catalog is used.

Invalid characters are most commonly the hyphen or dash ("-") character.

Common client-side problems include display problems and hyphens in names being interpreted as minus signs.

Various JavaScript run-time errors may occur.

Steps to Reproduce

Clarifying Information

In Progress Developer Studio for OpenEdge:

Schema include files may be generated from a database table as part of a Business Entity in the New Business Entity dialog, or they may be coded by hand and imported into the New Business Entity dialog.
The JSDO catalog is generated from the schema include file when a Data Object Service (Mobile service in OpenEdge 11.5 or earlier) is created with the New Data Object Service wizard, or when a defined service is edited using the Edit Data Object Service wizard.

Error Message

Defect Number

Enhancement Number

Cause

The primary cause of this problem is that the PDS New Data Object Service and Edit Data Object Service wizard code does not check whether names will be valid in JavaScript before generating the JSDO catalog.

A secondary cause is that if a new Business Entity is generated directly from a database table, the code does not check whether names will be valid in JavaScript before generating the schema include file so that valid SERIALIZE-NAME attributes can be added if necessary.

Resolution

It was determined that the Progress Product is functioning as designed.

An enhancement to the product can be requested through the Progress Community via an Ideas submission. Customer feedback is valuable and Idea submissions are monitored by our Product Management team. Enhancement requests are reviewed during the planning phase of each new product release and a list of the enhancements chosen for implementation can be found in the Release Notes documents that accompany each release. Once an Idea is submitted the Progress Software Community will have the opportunity to comment on and vote for the Idea.

For detailed information on how to submit an Idea, please refer to Knowledge Base article How to submit an idea for a Progress product enhancement (embedded video), .

Workaround

Add a SERIALIZE-NAME attribute to any dataset, temp-table, or field name containing a hyphen or any other character which is invalid for names in JavaScript. Do not include any characters which are invalid for JavaScript in the SERIALIZE-NAME. The generated catalog will use the SERIALIZE-NAME value instead of the NAME value whenever SERIALIZE-NAME is available.

When a Business Entity is generated directly from a database in the New Business Entity dialog, and one or more names contain hyphens or other invalid characters, edit the generated schema include file to remove JavaScript-invalid characters from the name or to add a SERIALIZE-NAME attribute with a value that does not contain invalid characters. Perform this step before editing the defined Data Object Service to generate the JSDO catalog.

Notes

References to Other Documentation:

Progress Data Objects Guide and Reference, "Overview of Progress Data Objects, Services, and Catalogs : Run-time architecture and data access"
https://documentation.progress.com/output/pdo/#page/pdo%2Frun-time-architecture-and-data-access.html

Progress Developer Studio for OpenEdge Online Help, "Data Object overview : Tasks : Working with Data Objects : Defining Data Object resources"
https://documentation.progress.com/output/OpenEdge116/openedge116/#page/pdsoe/defining-data-object-resources.html

Progress Articles:
JFP does not support SERIALIZE-NAME in JSDO catalog
Kendo UI Builder does not display data when field name contains hyphen

Keyword Phrase

Last Modified Date

11/20/2020 7:17 AM

JSDO catalog generated with characters that are invalid for JavaScript

Files(0)

Was this article helpful?

Was this article helpful?

JSDO catalog generated with characters that are invalid for JavaScript

Information

Related Articles