Error 1700 assigning name > 32 chars to a DATA-RELATION

DATA-RELATION with name length > 32 compiles and runs when used with a static ProDataSet but fails with error 1700 occurs when attempting to assign the same name to a relationship in a dynamic ProDataSet at runtime.

Jul 11, 2016
Knowledge

Title

URL Name

Error-1700-assigning-name-32-chars-to-a-DATA-RELATION

Article Number

000115666

Environment

Product: OpenEdge Version: 11.6.2 OS: Windows

Question/Problem Description

Error 1700 assigning name > 32 chars to a DATA-RELATION.

DATA-RELATION with name length > 32 compiles and runs when used with a static ProDataSet.

Error 1700 occurs when attempting to assign the same name to a relationship in a dynamic ProDataSet at runtime.

Steps to Reproduce

Clarifying Information

Code stub to demonstrate the behaviour:

DEFINE TEMP-TABLE ttTest1
    FIELD FieldA AS INTEGER
    FIELD FieldB AS INTEGER.
    
DEFINE TEMP-TABLE ttTest2
    FIELD FieldA AS INTEGER
    FIELD FieldB AS INTEGER.    
    
DEFINE TEMP-TABLE ttTest3
    FIELD FieldA AS INTEGER
    FIELD FieldB AS INTEGER.
    
DEFINE TEMP-TABLE ttTest4
    FIELD FieldA AS INTEGER
    FIELD FieldB AS INTEGER.        


/* Relation name is 33 characters long */
DEFINE DATASET dsTest FOR ttTest1, ttTest2 
    DATA-RELATION ProgressProgressProgressProgress1 FOR ttTest1, ttTest2 
    RELATION-FIELDS (FieldA,FieldB).
  

DEFINE VARIABLE hold AS HANDLE NO-UNDO.
DEFINE VARIABLE hrelold AS HANDLE NO-UNDO.
DEFINE VARIABLE hrelnew AS HANDLE NO-UNDO.
DEFINE VARIABLE hnew AS HANDLE NO-UNDO.

hold = DATASET dsTest:HANDLE.
hrelold = hold:GET-RELATION("ProgressProgressProgressProgress1").

CREATE DATASET hnew.
hnew:SET-BUFFERS(BUFFER ttTest3:handle, BUFFER ttTest4:handle).

hrelnew = hnew:ADD-RELATION(BUFFER ttTest3:handle, BUFFER ttTest4:handle, "FieldA,FieldB").
hrelnew:NAME = hrelold:NAME.

/* 
hrelnew:NAME = "ProgressProgressProgressProgress1".
*/

Error Message

Identifier was left blank or is more than <maximum> characters. (1700)

Defect Number

Defect PSC00347811

Enhancement Number

Cause

The exact cause is not known at this time.

Resolution

Until the fix is available, use the workaround below.

Workaround

Shorten the length of the DATA-RELATION name to 32 characters or less.

Notes

References to other documentation:

Progress article:
"Error 13128 is reported with READ-XML"

Keyword Phrase

Last Modified Date

11/20/2020 7:22 AM

Error 1700 assigning name > 32 chars to a DATA-RELATION

Files(0)

Was this article helpful?

Was this article helpful?

Error 1700 assigning name > 32 chars to a DATA-RELATION

Information

Related Articles