Consultor Eletrônico

ADM2 - Rule to Follow for Joins in an SDO (SmartDataObject)

Title: ADM2 - Rule to Follow for Joins in an SDO (SmartDataObject)

KnowledgeBase Number: 19129
Creation Date: 15-SEP-99
Modified Date: 16-SEP-99
This document applies to: Progress 9.0A and higher
Version and Release Number: 9.0B07

Summary:

If you have a SmartDataObject (SDO) that contains a join make certain
that no fields in the SDO have exactly the same name as any field
which exists in more than one of the tables involved in the join, even
if those fields have not been included in the SDO.

Rename all fields in the SDO (all, not just one).

Failure to rename the fields will cause multiple problems adding or
updating records because we will be unable to correctly match the
fields in the SDO with the correct fields in the tables.

For example, given the following tables and fields...

Table: AAA Table: BBB
Field: ID Field: ID
Field: Name Field: Name
Field: Amount Field: IsActive

Assuming a join of table AAA and table BBB with all fields from both
tables being in the SDO, you will need to rename the following fields
in the SDO:

AAA.ID
AAA.Name
BBB.ID
BBB.Name

Assuming a join of table AAA and table BBB with the following fields
being in the SDO:

AAA.ID
AAA.Name
BBB.IsActive

You will still need to rename the following fields in the SDO because
those field names exist in table BBB (even though they are not used in
the SDO):

AAA.ID
AAA.Name