Previewing the query

While creating a query, you can preview it to make sure it is retrieving the correct rows and columns.

StepsTo preview a query:

  1. Select Design>Preview from the menu bar.

    PowerBuilder retrieves the rows satisfying the currently defined query in a grid-style DataWindow object.

  2. 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 Chapter 16, “Managing the Database.”

  3. When you have finished previewing the query, click the Close button in the PainterBar to return to the Query painter.