If the data source is SQL (such as Quick Select, SQL Select, or Query), you can graphically modify the SQL SELECT statement.
Select Design>Data Source from the menu bar.
PowerBuilder 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.
Some changes you make (such as adding or removing columns) require PowerBuilder to modify the update capabilities of the DataWindow object.
For more information about controlling updates in a DataWindow object, see Chapter 21, “Controlling Updates in DataWindow objects.”
Changing the table
If you change the table referenced in the SELECT statement, PowerBuilder 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 18, “Defining DataWindow Objects.”
