Appeon PowerBuilder® 2019 R2
FOR WINDOWS
LAST REVISED: June 12, 2020
Copyright © 2019 Appeon. All rights reserved.
This publication pertains to Appeon software and to any subsequent release until otherwise indicated in new editions or technical notes. Information in this document is subject to change without notice. The software described herein is furnished under a license agreement, and it may be used or copied only in accordance with the terms of that agreement.
Upgrades are provided only at regularly scheduled software release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic, mechanical, manual, optical, or otherwise, without the prior written permission of Appeon Inc.
Appeon and other Appeon products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Appeon Inc.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP and SAP affiliate company.
Java and all Java-based marks are trademarks or registered trademarks of Oracle and/or its affiliates in the U.S. and other countries.
Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.
All other company and product names mentioned may be trademarks of the respective companies with which they are associated.
Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(ii) of DFARS 52.227-7013 for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.
Appeon Inc., 1/F, Shell Industrial Building, 12 Lee Chung Street, Chai Wan District, Hong Kong.
Table of Contents
- The PowerBuilder Environment
-
- Working with PowerBuilder
- Customizing PowerBuilder
- Using Source Control
- Working with Targets
-
- Working with Targets
- Working with Libraries
-
- About libraries
- Opening the Library painter
- About the Library painter
- Working with libraries
-
- Displaying libraries and objects
- Using the pop-up menu
- Controlling columns that display in the List view
- Selecting objects
- Filtering the display of objects
- Creating and deleting libraries
- Filtering the display of libraries and folders
- Working in the current library
- Opening and previewing objects
- Copying, moving, and deleting objects
- Setting the root
- Moving back, forward, and up one level
- Modifying comments
- Searching targets, libraries, and objects
- Optimizing libraries
- Regenerating library entries
- Rebuilding workspaces and targets
- Upgrading targets
- Exporting and importing entries
- Creating runtime libraries
- Creating reports on library contents
- Coding Fundamentals
-
- Writing Scripts
- Working with User-Defined Functions
- Working with User Events
- Working with Structures
- Working with Windows
-
- Working with Windows
- Working with Controls
-
- About controls
- Inserting controls in a window
- Selecting controls
- Defining a control's properties
- Naming controls
- Changing text
- Moving and resizing controls
- Copying controls
- Defining the tab order
- Defining accelerator keys
- Specifying accessibility of controls
- Choosing colors
- Using the 3D look
- Using the individual controls
-
- CommandButton
- PictureButton
- CheckBox
- RadioButton
- StaticText
- StaticHyperLink
- Picture
- PictureHyperLink
- GroupBox
- Drawing controls
- SingleLineEdit and MultiLineEdit
- EditMask
- HScrollBar and VScrollBar
- HTrackBar and VTrackBar
- HProgressBar and VProgressBar
- DropDownListBox
- DropDownPictureListBox
- ListBox
- PictureListBox
- ListView
- TreeView
- Tab
- MonthCalendar
- DatePicker
- Animation
- InkEdit and InkPicture
- Understanding Inheritance
- Working with RibbonBar
- Working with WebBrowser
- Working with Menus and Toolbars
- Working with User Objects
- Working with Databases
-
- Managing the Database
-
- Working with database components
- Managing databases
- Using the Database painter
- Creating and deleting a SQL Anywhere database
- Working with tables
-
- Creating a new table from scratch
- Creating a new table from an existing table
- Specifying column definitions
- Specifying table and column properties
- Altering a table
- Cutting, copying, and pasting columns
- Closing a table
- Dropping a table
- Viewing pending SQL changes
- Printing the table definition
- Exporting table syntax
- About system tables
- Creating and editing temporary tables
- Working with keys
- Working with indexes
- Working with database views
- Manipulating data
- Creating and executing SQL statements
- Controlling access to the current database
- Using the ASA MobiLink synchronization wizard
- Managing MobiLink synchronization on the server
- Working with Data Pipelines
- Working with DataWindows
-
- Defining DataWindow Objects
-
- About DataWindow objects
- Choosing a presentation style
- Building a DataWindow object
- Selecting a data source
- Using Quick Select
- Using SQL Select
- Using Query
- Using External
- Using Stored Procedure
- Using a Web service data source (Obsolete)
- Using the OData Service (Obsolete)
- Choosing DataWindow object-wide options
- Generating and saving a DataWindow object
- Defining queries
- What's next
- Enhancing DataWindow Objects
-
- Working in the DataWindow painter
-
- Understanding the DataWindow painter Design view
- Using the DataWindow painter toolbars
- Using the Properties view in the DataWindow painter
- Selecting controls in the DataWindow painter
- Resizing bands in the DataWindow painter Design view
- Using zoom in the DataWindow painter
- Undoing changes in the DataWindow painter
- Using the Preview view of a DataWindow object
- Saving data in an external file
- Modifying general DataWindow object properties
-
- Changing the DataWindow object style
- Setting colors in a DataWindow object
- Setting gradients and background pictures in a DataWindow object
- Setting transparency properties for a DataWindow object
- Specifying properties of a grid DataWindow object
- Specifying pointers for a DataWindow object
- Defining print specifications for a DataWindow object
- Modifying text in a DataWindow object
- Defining the tab order in a DataWindow object
- Naming controls in a DataWindow object
- Using borders in a DataWindow object
- Specifying variable-height bands in a DataWindow object
- Modifying the data source of a DataWindow object
- Storing data in a DataWindow object using the Data view
- Retrieving data
- Working with Controls in DataWindow Objects
-
- Adding controls to a DataWindow object
-
- Adding columns to a DataWindow object
- Adding text to a DataWindow object
- Adding drawing controls to a DataWindow object
- Adding a group box to a DataWindow object
- Adding pictures to a DataWindow object
- Adding computed fields to a DataWindow object
- Adding buttons to a DataWindow object
- Adding graphs to a DataWindow object
- Adding InkPicture controls to a DataWindow object
- Adding OLE controls to a DataWindow object
- Adding reports to a DataWindow object
- Adding table blob controls to a DataWindow object
- Adding tooltips to a DataWindow control
- Reorganizing controls in a DataWindow object
-
- Displaying boundaries for controls in a DataWindow object
- Using the grid and the ruler in a DataWindow object
- Deleting controls in a DataWindow object
- Moving controls in a DataWindow object
- Copying controls in a DataWindow object
- Resizing controls in a DataWindow object
- Aligning controls in a DataWindow object
- Equalizing the space between controls in a DataWindow object
- Equalizing the size of controls in a DataWindow object
- Sliding controls to remove blank space in a DataWindow object
- Positioning controls in a DataWindow object
- Rotating controls in a DataWindow object
- Controlling Updates in DataWindow objects
-
- About controlling updates
- Specifying the table to update
- Specifying the unique key columns
- Specifying an identity column
- Specifying updatable columns
- Specifying the WHERE clause for update/delete
- Specifying update when key is modified
- Using stored procedures to update the database
- Using a Web service to update the database (Obsolete)
- Displaying and Validating Data
-
- About displaying and validating data
- About display formats
- Working with display formats
- Defining display formats
- About edit styles
- Working with edit styles
- Defining edit styles
- Defining a code table
- About validation rules
- Working with validation rules
- Defining validation rules
- How to maintain extended attributes
- Filtering, Sorting, and Grouping Rows
- Highlighting Information in DataWindow Objects
- Using Nested Reports
-
- About nested reports
- Creating a report using the Composite presentation style
- Placing a nested report in another report
- Working with nested reports
-
- Adjusting nested report width and height
- Changing a nested report from one report to another
- Modifying the definition of a nested report
- Adding another nested report to a composite report
- Supplying retrieval arguments to relate a nested report to its base report
- Specifying criteria to relate a nested report to its base report
- Using options for nested reports
- Working with Graphs
- Working with Crosstabs
- Working with TreeViews
- Exporting and Importing XML Data
- Working with Rich Text
- Using OLE in a DataWindow Object
- Running Your Application
-
- Debugging and Running Applications
- Tracing and Profiling Applications
- Creating Executables and Components
-
- About building PowerBuilder targets
- Creating a project
- Using the Project painter
- Defining an executable application project
- Using dynamic libraries
- Attaching or embedding manifest files
- Distributing resources
- Tracing execution
- Building an executable file and dynamic libraries
- Building proxies and .NET targets
- Appendixes