Specifications

CHAPTER 6 Enhancing Reports
Users Guide 229
2 Modify the
SELECT statement graphically using the same techniques as
when creating it.
For more information, see “Using SQL Select” on page 165.
Modifying the statement syntactically
Select Design>Convert to Syntax from the menu bar to modify the
SELECT statement syntactically.
3 Click the Return button to return to the painter.
Changing the table
If you change the table referenced in the SELECT statement, InfoMaker
maintains the columns in the Design view (now from a different table) only if
they match the datatypes and order of the columns in the original table.
Modifying the retrieval
arguments
You can add, modify, or delete retrieval arguments when modifying your data
source.
❖ To modify the retrieval arguments:
1 In the SQL Select painter, select Design>Retrieval Arguments from the
menu bar.
The Specify Retrieval Arguments dialog box displays, listing the existing
arguments.
2 Add, modify, or delete the arguments.
3 Click OK.
You return to the SQL Select painter, or to the text window displaying the
SELECT statement if you are modifying the SQL syntactically.
4 Reference any new arguments in the
WHERE or HAVING clause of the
SELECT statement.
For more information about retrieval arguments, see Chapter 5, “Defining
Reports.”