This is an old revision of the document!



Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays


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