Using retrieval arguments – PB Docs 2017
Using retrieval arguments If you know which rows will be retrieved into the DataWindow object at runtime—that is, if you can fully specify the SELECT statement without having to provide a variable—you do not need to specify retrieval arguments. Adding retrieval arguments If you decide later that you need arguments, you can return to the…
DataWindow expressions – PB Docs 2017
DataWindow expressions Adding a DataWindow expression opens the Modify Expression dialog box. This enables you to create references to columns from the data source of the DataWindow object. One use of this feature is to return a fragment of XML to embed, providing another level of dynamic XML generation. Using Date and DateTime with strings…
Selecting columns – PB Docs 2017
Selecting columns You can click each column you want to include from the table representations in the Table Layout view. PowerBuilder highlights selected columns and places them in the Selection List at the top of the SQL Select painter. To reorder the selected columns Drag a column in the Selection List with the mouse. Release…
Writing Scripts – PB Docs 2017
Writing Scripts Contents About the Script view Opening Script views Modifying Script view properties Editing scripts Using AutoScript Getting context-sensitive Help Compiling the script Declaring variables and external functions About this chapter PowerBuilder applications are event driven. You specify the processing that takes place when an event occurs by writing a script. This chapter describes…
Root element – PB Docs 2017
Root element You can change the name of the root element, add attributes and children, and insert comments, instructions, and, if they do not already exist, XML and/or document type declarations before it. Changing the name of the root element changes the name of its start and end tags. You can change the name using…
Revert changes – PB Docs 2017
Revert changes For objects that are changed locally but not yet synchronized to the SVN source control system, you can give up the local changes and restore to the version in the source control system. To revert objects from the SVN source control system: Right-click the workspace, target, library, or object in the System Tree…
Show logs – PB Docs 2017
Show logs You can view the file revision log messages. PowerBuilder IDE provides no log viewer utility; it supports only TortoiseSVN (for SVN) and TortoiseGit (for Git) and you must specify the executable file of TortoiseSVN or TortoiseGit first. To specify the executable file of TortoiseSVN for viewing log messages: Right-click the workspace in the…
Working with Targets – PB Docs 2017
Working with Targets This part describes how to work with targets in painters, how to set properties for an application, and how to manage PowerBuilder libraries. Contents Working with Targets About targets Working in painters About the Application painter Specifying application properties Writing application-level scripts Specifying target properties Looking at an application’s structure Working with…
Working with Windows – PB Docs 2017
Working with Windows This part describes how to create windows for your application. It covers the properties of windows, the controls you can place in windows, how to use inheritance to save time and effort, and how to define menus. It also introduces user objects. Contents Working with Windows About windows Types of windows About…
Retrieving data – PB Docs 2017
Retrieving data Where PowerBuilder gets data PowerBuilder follows this order of precedence to supply the data in your DataWindow object: If you have saved data in the DataWindow object, PowerBuilder uses the saved rows from the DataWindow object and does not retrieve data from the database. PowerBuilder uses the data in the cache, if there…