Ispirer Website Ispirer Capabilities - PowerBuilder Conversion Free Trial

PowerBuilder - DataWindow Object

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

DataWindow .SRD File

  • 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=~"") COLUMN(NAME=~"dbo.stores.location~"))" 

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.