Modifying SQL SELECT statements
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.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”.
Modifying the statement syntactically
Select Design>Convert to Syntax from the menu bar
to modify the SELECT statement syntactically. -
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.
Modifying the retrieval arguments
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 .”