Specifications

Using the Query Governor
48 InfoMaker
❖ To identify a library as a source of form styles:
1 Click the Library List button in the PowerBar.
2 On the Style tab page, enter one or more library search paths in the Library
Search Path box, or click Browse to select a library search path and then
click Open to add the library to the Library Search Path box.
If the page is disabled
If the Style page is disabled, close the dialog box and close any open
painters before trying again.
3 Click OK.
InfoMaker sets the library search path for user-defined form styles. When
you create a new form, the form styles defined in your organization display
in the Form Style box in the New Form dialog box.
Using the Query Governor
The Query Governor lets you set data selection and retrieval options for
InfoMaker. Then, when you select and retrieve data, the Query Governor limits
that you set apply.
Data selection options
Table 1-10 shows the data selection options you can set.
Table 1-10: Query Governor data selection options
Data selection options Description
Specify the maximum
number of tables in a join
Specifying a maximum limits data selection.
Increasing the maximum means fewer restrictions on
data selection and longer retrieval times.
Allow cross products When cross products are allowed, you can have
tables not joined by the join operator. One row is
retrieved for each combination of rows in the tables.
If table A has x rows and table B has y rows, a cross
product of A and B has x times y rows, unless you
specify
WHERE criteria.
Allow outer joins When outer joins are allowed, all rows in a table are
retrieved whether or not a matching row exists in
another table.