Enable relational finds

Command group Flag affected Reversible Execute on client Platform(s)
Finding data NO YES NO All

Syntax

Enable relational finds ([Use connections]) {list-of-files (F1,F2,..,Fn)}

Options

Use connections If specified, all connections between the joined files are made when building the table

Description

This command causes all find tables to be built relationally, ignoring the main file. The file list is a list of files to be joined and, if Use connections is checked, all connections between the joined files are made when building the table. In effect, the connections provide the relational joins, that is, "sequence number = sequence number".

When relational finds are enabled, the index field specified for find and build list commands is ignored. It is necessary to use a sort to determine the order of the table.

The Disable relational finds command causes a reversion to the default situation where the main file and its connected parent files are joined using the connections. The Enable relational finds and Disable relational finds commands are both reversible and do not affect the flag.

Example

Set current list lMyList
Define list {fChild,fParent,fGrandParent}
; Build a relational child/parent/grandparent list using omnis connections
Enable relational finds (Use connections) {fChild,fParent,fGrandparent}
Build list from file