Kbase P93949: How to create SDO with joins using Object Generator
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/3/2004 |
|
Status: Unverified
GOAL:
How to create SDO with joins using Object Generator
GOAL:
How to use the "Follow Joins" option when creating SDO
FACT(s) (Environment):
Dynamics 2.0A
Dynamics 2.1A
OpenEdge 10.x
FIX:
The Object Generator can create joins to other related tables automatically, if your database schema conforms to the Progress Dynamics conventions. This means you must meet the following conditions:
Your join fields must be conformant Object ID fields with names derived from the table name.
You must have an Entity Description field with an appropriate name; or you could have identified the Entity Description field in Entity Maintenance.
If these conditions are met, and you leave the Follow Joins toggle box checked on, then the Object Generator adds joins to other related tables to the SDO query, and adds the Entity Description field for each other table to the field list. You can then add these fields to a Browser or Viewer for the SDO.
If your database does not allow the framework to determine the proper joins and related fields, you can add these other tables and fields yourself after the SDOs are generated, as described earlier.