Progress
Results User’s Guide
for UNIX
Relations Between Files
Use the Relations Between Files option in the Administration to join files that are not related automatically. Files are automatically related if they have indexed fields with the same name and at least one of the indexes is unique. This option enables you to establish relationships between files not sharing field names. For more information about relations between files, see the Progress Language Tutorial for Character or the Progress Language Tutorial for Windows.
When you start Results for the first time, the system uses the Progress “OF” operator to join files that have common field names. It also determines which files contain fields with the same names, and whether indexes exist with duplicate fields as leading components.
When you select this option, you see a list that names all of the files in the connected databases. After you select the first file in the relationship, another list of filenames appears and you can select the second file in the relation.
For example, if you select the customer file in the mysports database, the screen shown in Figure 9–3 appears.
Figure 9–3: Selecting the Second File for a File Relation
![]()
In this example, an asterisk (*) marks each file that has a defined relation with the customer file. You can select other files to relate to the customer file, or you can remove any relation. (To mark any file, highlight it and press RETURN.) Default relations use OF criteria. You can define nondefault relations using WHERE criteria.
You can add as many as 20 lines of WHERE or OF clause information in this window. Use any of the keys described in "General Information," to edit the information in this window. For example, you can press GET to display a list of available fields that you can use to build the relation. Once you add the relationship, the reverse relation appears automatically.
NOTE: To define a relation between files that do not have a common field, you must relate each of the files to a file that has at least one field in common with each of them.To delete a relation between two related files, select the related file in the list, then delete the WHERE or OF clause. To delete the relation, delete the OF clause from the window. The next time you view the file relation list, files will no longer be marked with an asterisk.
When you exit from the Administration module, Results updates the QC configuration file. The next time you choose the Join option in the Query, Reports, Labels, or Data Export modules, you will see the new relationships along with the existing relationships.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |