Ispirer Home Page
Ispirer SQLWays Product Page - PowerBuilder Conversion
Request SQLWays
DataWindow objects are used to retrieve, display, and manipulate data in PowerBuilder applications.
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-2021, Ispirer Systems Ltd. All Rights Reserved. Privacy Statement |