Appeon PowerBuilder® 2021
FOR WINDOWS
LAST REVISED: November 17, 2021
Copyright © 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 Targets
-
- Working with Targets
- Working with Libraries
-
- About libraries
- Opening the Library painter
- About the Library painter
- Working with libraries
- 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
- 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
- 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
- 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 with Controls in DataWindow Objects
- 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
- 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
- Appendixes
