If the data source is SQL (such as Quick Select, SQL Select, or Query), you can graphically modify the SQL SELECT statement.
To modify a SQL data
source:
Select Design>Data Source from the menu bar.
InfoMaker returns you to the SQL Select painter. (If you used Quick Select to define the data source, this might be the first time you have seen the SQL Select painter.)
Modify the SELECT statement graphically using the same techniques as when creating it.
For more information, see “Using SQL Select”.
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.
You can add, modify, or delete retrieval arguments when modifying your data source.
To modify the retrieval arguments:
In the SQL Select painter, select Design>Retrieval Arguments from the menu bar.
The Specify Retrieval Arguments dialog box displays, listing the existing arguments.
Add, modify, or delete the arguments.
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.
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.”
