| Command group | Flag affected | Reversible | Execute on client | Platform(s) |
|---|---|---|---|---|
| Finding data | NO | YES | NO | All |
Enable relational finds ([Use connections]) {list-of-files (F1,F2,..,Fn)}
| Use connections | If specified, all connections between the joined files are made when building the table |
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.
Set current list lMyList
Define list {fChild,fParent,fGrandParent}
# Build a relational child/parent/grandparent list using omnis connections
Enable relational finds (Use con) {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)