PowerBuilder - DataWindow Object

DataWindow objects are used to retrieve, display, and manipulate data in PowerBuilder applications.

• Retrieve section

The Retrieve section of a DataWindow object defines the query for data retrieval.

It can contain the actual SQL SELECT statement:

retrieve="SELECT name, location FROM dbo.stores" 

Or if the datasource is built graphically, it contains the SQL SELECT statement in PBSELECT format, which is PowerBuilder's own format for describing a SQL SELECT statement:

retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"dbo.stores~" ) COLUMN(NAME=~"dbo.stores.name~") COLUMN(NAME=~"dbo.stores.location~"))" 

SQLWays Product Page - PowerBuilder Conversion Free Evaluation