Users Guide
Appeon PowerBuilder® 2017 R3
FOR WINDOWS
LAST REVISED:
July 17, 2018
Copyright © 2018 by Appeon
Limited. 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 Limited.
Appeon and other Appeon
products and services mentioned herein as well as their respective logos
are trademarks or registered trademarks of Appeon Limited.
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 Limited, 1/F,
Shell Industrial Building, 12 Lee Chung Street, Chai Wan District, Hong
Kong.
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
- Migrating 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 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 (Deprecated)
- Using the OData Service (Deprecated)
- 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 (Deprecated)
- 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
-
- 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