While creating a query, you can preview it to make sure it is retrieving the correct rows and columns.
To preview a query
-
Select Design > Preview from the menu bar.
PowerBuilder retrieves the rows satisfying the currently defined query in a grid-style DataWindow object.
-
Manipulate the retrieved data as you do in the Database painter in the Output view.
You can sort and filter the data, but you cannot insert or delete a row or apply changes to the database. For more about manipulating data, see Managing the Database.
-
When you have finished previewing the query, click the Close button in the PainterBar to return to the Query painter.
