Introduction to PowerBuilder

Saving as a Query

You may want to save a defined SQL SELECT statement for future use. The simplest way to do this is to save it as a query for re-use. Select 'File > Save Query' or 'File > Save Query As...' menu option.

A query is stored in the PowerBuilder library, along with all other objects in the current application, as opposed to saving it as a text file containing the SQL statements themselves.

You can also create queries outside the DataWindow Painter; this environment is called the Query Painter. You can then choose to create a DataWindow based upon an existing query. We'll look at this next.

Home	Previous Lesson: Joining Tables Next Lesson: Query as a Data Source