Enable relational finds

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

Syntax

Options

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
 
# Build a relational list of records ignoring omnis connections from fParent

# and fChild of parents with children less than 4 years old

Set search as calculation
 
fParent
.
ID
=
fChild
.
Parent_ID
&
fChild
.
Age
<4

Enable relational finds
 
fParent,fChild

Build list from file
 (
Use search
)