Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Calculated fields in Dynamic SDO with join misbehave

Calculated fields may show one or more of the following:

Incorrect formatting is applied

Incorrect initial values are provided

In addition to symptoms directly affecting the calculated fields, calls to the SDO data logic procedure may also fail with varying errors relating to temp-table schema mismatches.

<DLP Procedure> Cannot bind BY-REFERENCE parameter tables or datasets unless column datatypes, positions, extents and indexes match for tables RowObjUpd and rowObjUpd. (12766)


<program-name> Cannot bind BY-REFERENCE parameter tables or datasets unless column datatypes, positions, extents and indexes match for tables <name> and <name>. (12766)

FACT(s) (Environment):

Both tables in the join have calculated fields defined in their repository's entity definitions
Both tables also have one or more of these SDO Entity calculated fields included in the SDO
The calculated fields from the right-hand table of the join appear before those of the left-hand table in the list of fields in the SDO
OpenEdge 10.1C
OpenEdge 10.2x
Dynamics
All Supported Operating Systems

CAUSE:

Bug# OE00191743

FIX:

Workaround:


Reorder the calculated fields so that those belonging to the left-hand side entity of the join appear before those of the right-hand side entity.