Queries in PowerBuilder .NET

When you choose a query as the data source, you select a predefined SQL SELECT statement (a query) as specifying the data for your DataWindow object.

Queries save time, because you specify all the data requirements just once. For example, you can specify the columns, which rows to retrieve, and the sorting order in a query. Whenever you want to create a DataWindow object using that data, simply specify the query as the data source.

In PowerBuilder .NET version 12.5:

If you import a target with existing queries, you can use those queries.
You can create new queries by saving from the SQL Select dialog. See Using SQL Select.

You can edit existing queries using the text editor.

Previewing the Query
Preview a query to make sure it is retrieving the correct rows and columns.
Saving the Query
Save a query at any time you are working on it.
Modifying the Query
Use the text editor to modify existing queries. Before doing so, be familiar with PowerBuilder SELECT syntax.

Parent topic: DataWindows