Ispirer Ispirer
 


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

sqlways/powerbuilder/datawindow-object.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement