Getting Started

Appeon PowerBuilder® 2021


DOCUMENT ID: DC37772-01-1900-01

LAST REVISED: July 29, 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)(1)(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

Welcome to PowerBuilder
Introduction to PowerBuilder
What PowerBuilder is
The PowerBuilder environment
PowerBuilder objects
About the PowerBuilder Tutorial
Learning to build a client/server application
How you will proceed
Setting up for the tutorial
Building a Client/Server Application
LESSON 1 Starting PowerBuilder
Create a new workspace
Create a target
Specify an icon for the application
Change the size of the main window
Run the application
LESSON 2 Customizing the PowerBuilder Environment
Manipulate the System Tree window
Open an object
Manipulate views
Set up the toolbars
LESSON 3 Building a Login Window
Create a new window
Add controls to the window
Change the tab order on the window
Code some Help events and preview the window
Write the script to open the window
LESSON 4 Connecting to the Database
Look at the Demo Database
Run the Connection Object wizard
Declare a global variable
Modify the connection information
Complete the login and logout scripts
Run the application
LESSON 5 Modifying the Ancestor Window
Add a library to the search path
Create a new ancestor sheet window
Create a new sheet window inheritance hierarchy
Add a DataWindow control for the master DataWindow
Add a DataWindow control for the detail DataWindow
View the scripts inherited from the user object
Add user events and event scripts
Add scripts to retrieve data for the DataWindow controls
Adjust a runtime setting for sheet window size
LESSON 6 Setting Up the Menus
Modify the frame menu
Create a new sheet menu
Add menu scripts to trigger user events
Attach the new menu and run the application
LESSON 7 Building DataWindow Objects
Create and preview a new DataWindow object
Save the DataWindow object
Make cosmetic changes to the first DataWindow object
Create a second DataWindow object
Make cosmetic changes to the second DataWindow object
LESSON 8 Attaching the DataWindow Objects
Attach the DataWindow object to the master DataWindow control
Attach the DataWindow object to the detail DataWindow control
Run the application
Attach DataWindow objects to the Product window
Run the application again
LESSON 9 Running the Debugger
Add breakpoints in application scripts
Run in debug mode
Set a watch and a conditional breakpoint
LESSON 10 Exception Handling
Add a new sheet window to the existing application
Create user-defined exception objects
Create a new user function and user event
Call the methods and catch the exceptions
Run the application
LESSON 11 Preparing the Application for Deployment
Create the Project object
Create the executable file
Create a shortcut
Test the executable file
What to do next