Home
PowerBuilder
Appeon Documentation Center
JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
Home
PowerBuilder
Appeon Documentation Center
Users Guide
Creating Executables and Components
Sidebar
Prev
|
Up
|
Next
Working with a .NET DataStore project
Overview
Creating a .NET DataStore project
Creating a database connection
Defining a .NET DataStore project
Configuring the global settings
Generating and building a .NET DataStore project
Running a .NET DataStore project
Editing or publishing a .NET DataStore project
Calling APIs from PowerScript
Contents
Search
The PowerBuilder Environment
Working with PowerBuilder
About PowerBuilder
Concepts and terms
Workspaces/Solutions and targets/projects
Objects
DataWindow objects
PowerBuilder libraries
Painters and editors
Events and scripts
Functions
Properties
Source control
PowerBuilder extensions
The PowerBuilder environment
The System Tree
The PowerBar
The Clip window
The Output window
Creating and opening workspaces/solutions
Creating a workspace/solution
Opening a workspace/solution
Using wizards
About wizards
Creating a target/project
Target/Project types
Application targets/projects
Managing workspaces/solutions
Adding an existing target/project to a workspace/solution
Removing a target/project from a workspace/solution
Specifying workspace/solution properties
Building workspaces/solutions
In the development environment
From a command line
Using PBAutoBuild standalone tool
Working with tools
Using the To-Do List
Using the file editor
Using online help
Building an application
Customizing PowerBuilder
Starting PowerBuilder with an open workspace/solution
Using options in the development environment
Using a workspace/solution file
Using command line arguments
Changing default layouts
Arranging the System Tree, Output, and Clip windows
Using views in painters
Displaying the title bar
Moving and resizing panes and views
Floating and docking views
Adding and removing views
Saving a layout
Using toolbars
Toolbar basics
Drop-down toolbars
Controlling the display of toolbars
Moving toolbars using the mouse
Docking toolbars
Customizing toolbars
Modifying a custom button
Creating new toolbars
Customizing keyboard shortcuts
Changing fonts
Defining colors
How the PowerBuilder environment is managed
About the registry
About the initialization file
Using Source Control
About source control systems
Using SVN or Git
Using TFS
Using source control manager via SCC API
Using PBNative
Constraints of a multi-user environment
Extension to the SCC API
Using proxy server
Using SVN source control system
Add a workspace/solution to SVN
Get a workspace/solution from SVN
Commit objects to SVN
Get objects from SVN
Resolve conflicts
Remove the binary property from a R3 source-controlled workspace
Revert changes
Refresh objects
Upload PBL
Lock objects
Tools for Show Log\Edit Conflicts
Compare objects
View/Edit the connection settings
View the status of source-controlled objects
Using Git source control system
Add a workspace/solution to Git
Get a workspace/solution from Git
Commit objects to Git
Get objects from Git
Resolve conflicts
Revert changes
Refresh objects
Upload PBL
Tools for Show Log\Edit Conflicts
Compare objects
Use branches
Use .gitignore
View/Edit the connection settings
View the status of source-controlled objects
Using source control systems via SCC API
Using a source control system with PowerBuilder
Setting up a connection profile
Viewing the status of source-controlled objects
Working in offline mode
Fine-tuning performance for batched source control requests
Files available for source control
Source control operations via SCC API in PowerBuilder
Adding objects to source control
Checking objects out from source control
Checking objects in to source control
Clearing the checked-out status of objects
Synchronizing objects with the source control server
Refreshing the status of objects
Comparing local objects with source control versions
Displaying the source control version history
Removing objects from source control
Initialization settings that affect source control
Modifying source-controlled targets and objects
Effects of source control on object management
Opening objects checked in to source control
Copy and move operations on source-controlled objects
Editing the PBG file for a source-controlled target
Upgrading existing projects under source control
Using the Existing Application target wizard
Importing source control files to a new library
Working with Targets/Projects
Working with Targets/Projects
About targets/projects
Working in painters
Opening painters
Painter summary
Painter features
Views in painters that edit objects
About the Application painter
Specifying application properties
Specifying default text properties
Specifying an icon
Specifying default global objects
Specifying a rich text editor
Specifying a theme for the application UI
UI Theme
System themes
Custom themes
Configuring the custom theme
Precedence
Applying a theme
Making the theme effective
Packaging the theme runtime files
Turning off the theme
Understanding the theme.json file
Understanding what can be set by the theme
Windows and User Objects
Controls
DataWindows
Understanding what additional features provided by the theme
Understanding the event differences
Theme feature limitation
Writing application-level scripts
Setting application properties in scripts
Specifying target/project properties
Specifying the target/project's library search path
Looking at an application's structure
Which objects are displayed
Which references are displayed
Which references are not displayed
Working with objects
Creating new objects
Creating new objects using inheritance
Naming conventions
Opening existing objects
Running or previewing objects
Using the Source editor
Working with Libraries
About libraries
Using libraries
Organizing 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/projects, libraries, and objects
Optimizing libraries
Regenerating library entries
Rebuilding workspaces/solutions and targets/projects
Upgrading targets/projects
Exporting and importing entries
Creating runtime libraries
Including additional resources
Creating reports on library contents
Creating library entry reports
Creating the library directory report
Coding Fundamentals
Writing Scripts
About the Script editor
Modifying Script editor properties
Opening Script editor
Editing scripts
Limiting size of scripts
Printing scripts
Pasting information into scripts
Finding and replacing scripts
Reverting to the unedited version of a script
Using AutoScript
Using the AutoScript pop-up window
Customizing AutoScript
Using Parameter Info
Using QuickInfo
Getting context-sensitive Help
Compiling the script
Handling problems
Compiler Errors
C0001 Compiler Error
C0002 Compiler Error
C0003 Compiler Error
C0004 Compiler Error
C0005 Compiler Error
C0006 Compiler Warning
C0007 Compiler Error
C0008 Compiler Error
C0009 Compiler Error
C0010 Compiler Error
C0011 Compiler Error
C0013 Compiler Error
C0014 Compiler Warning
C0015 Compiler Error
C0016 Compiler Error
C0017 Compiler Error
C0018 Compiler Error
C0019 Compiler Error
C0020 Compiler Error
C0021 Compiler Error
C0022 Fatal Compiler Error
C0023 Compiler Error
C0024 Compiler Error
C0025 Compiler Error
C0026 Compiler Error
C0027 Compiler Error
C0028 Compiler Error
C0029 Compiler Error
C0030 Fatal Compiler Error
C0031 Compiler Error
C0032 Fatal Compiler Error
C0033 Compiler Error
C0034 Compiler Error
C0035 Compiler Error
C0036 Compiler Error
C0037 Compiler Error
C0038 Database Error
C0039 Compiler Error
C0040 Compiler Error
C0041 Compiler Error
C0042 Compiler Error
C0043 Compiler Error
C0044 Compiler Error
C0045 Compiler Error
C0046 Compiler Error
C0047 Compiler Error
C0048 Compiler Error
C0049 Compiler Error
C0050 Compiler Error
C0051 Compiler Error
C0052 Compiler Error
C0053 Compiler Error
C0054 Database Error
C0055 Compiler Error
C0056 Compiler Error
C0057 Compiler Error
C0058 Compiler Warning
C0059 Compiler Warning
C0060 Compiler Error
C0061 Compiler Error
C0062 Compiler Error
C0063 Compiler Error
C0064 Compiler Error
C0065 Compiler Error
C0066 Compiler Error
C0067 Compiler Error
C0068 Compiler Error
C0069 Compiler Error
C0070 Compiler Error
C0071 Compiler Error
C0072 Compiler Error
C0073 Compiler Warning
C0074 Compiler Error
C0075 Compiler Warning
C0076 Compiler Error
C0077 Compiler Error
C0078 Compiler Error
C0079 Compiler Error
C0080 Compiler Error
C0081 Compiler Error
C0082 Compiler Error
C0083 Compiler Error
C0084 Compiler Error
C0085 Compiler Error
C0086 Compiler Warning
C0087 Compiler Warning
C0088 Compiler Warning
C0089 Compiler Warning
C0090 Compiler Error
C0091 Compiler Error
C0092 Compiler Error
C0093 Compiler Error
C0094 Compiler Error
C0095 Compiler Error
C0096 Compiler Error
C0097 Compiler Error
C0098 Compiler Error
C0099 Compiler Warning
C0100 Compiler Error
C0101 Compiler Error
C0102 Compiler Error
C0103 Compiler Error
C0104 Compiler Error
C0105 Compiler Error
C0106 Compiler Error
C0107 Compiler Error
C0108 Compiler Error
C0109 Compiler Error
C0110 Compiler Warning
C0111 Compiler Error
C0112 Compiler Error
C0113 Compiler Error
C0114 Compiler Error
C0115 Compiler Error
C0116 Compiler Error
C0117 Compiler Error
C0118 Compiler Error
C0119 Compiler Error
C0120 Compiler Error
C0121 Compiler Error
C0122 Compiler Error
C0123 Compiler Error
C0124 Compiler Error
C0125 Compiler Error
C0126 Compiler Error
C0127 Compiler Error
C0128 Compiler Error
C0129 Compiler Warning
C0130 Compiler Error
C0131 Compiler Error
C0132 Compiler Error
C0133 Compiler Error
C0134 Compiler Error
C0135 Compiler Error
C0136 Compiler Error
C0137 Compiler Error
C0138 Compiler Error
C0139 Compiler Error
C0140 Compiler Error
C0141 Compiler Error
C0142 Compiler Error
C0143 Compiler Error
C0144 Compiler Error
C0145 Compiler Error
C0146 Informational Message
C0147 Informational Message
C0148 Informational Message
C0149 Informational Message
C0150 Compiler Warning
C0151 Compiler Warning
C0152 Compiler Error
C0153 Compiler Error
C0154 Compiler Error
C0155 Compiler Error
C0156 Compiler Warning
C0157 Informational Message
C0158 Compiler Error
C0159 Compiler Error
C0160 Compiler Error
C0161 Compiler Error
C0162 Compiler Error
C0163 Compiler Error
C0164 Compiler Error
C0165 Compiler Error
C0166 Compiler Error
C0167 Compiler Error
C0168 Informational Message
C0169 Compiler Error
C0170 Compiler Error
C0171 Compiler Warning
C0172 Compiler Error
C0173 Compiler Error
C0174 Compiler Error
C0175 Compiler Error
C0176 Compiler Error
C0177 Compiler Error
C0178 Compiler Warning
C0179 Compiler Warning
C0180 Compiler Error
C0181 Compiler Error
C0182 Compiler Error
C0183 Compiler Error
C0184 Compiler Error
C0185 Obsolete Warning
C0186 Compiler Warning
C0187 Compiler Error
C0188 Compiler Warning
C0189 Compiler Error
C0190 Compiler Warning
C0191 Compiler Error
C0192 Compiler Error
C0193 Compiler Error
C0194 Compiler Error
C0195 Compiler Error
C0196 Compiler Error
C0197 Informational Message
C0198 Compiler Warning
C0199 Compiler Warning
C0200 Compiler Error
C0201 Compiler Error
C0202 Compiler Error
C0203 Compiler Error
C0204 Compiler Error
C0205 Migration Warning
C0206 Migration Warning
C0207 Migration Warning
C0208 Informational Message
C0209 Compiler Warning
C0210 Compiler Warning
C0212 Compiler Error
C0213 Compiler Error
C0214 Compiler Error
C0215 Compiler Error
C0216 Compiler Error
C0217 Informational Message
C0218 Compiler Warning
C0300 Compiler Error
C0301 Compiler Error
C0302 Compiler Error
C0303 Compiler Error
C0304 Compiler Error
C0305 Compiler Error
C0306 Compiler Error
C0307 Compiler Error
C0308 Compiler Error
C0309 Compiler Error
C0310 Compiler Error
C0311 Compiler Error
C0312 Compiler Error
C0313 Compiler Error
C0314 Compiler Warning
C0315 Compiler Warning
C0316 Compiler Error
C0317 Compiler Warning
C0318 Compiler Warning
C0319 Compiler Error
C0320 Compiler Error
C0321 Compiler Error
C0322 Compiler Error
C0323 Compiler Warning
C0324 Compiler Warning
C0325 Compiler Error
C0326 Compiler Error
C0327 Compiler Error
C0328 Compiler Error
C0329 Compiler Error
C0330 Compiler Error
C0331 Compiler Error
Declaring variables and external functions
Working with User-Defined Functions
About user-defined functions
Deciding which kind you want
Defining user-defined functions
Opening a Prototype window to add a new function
Defining the access level
Defining a return type
Naming the function
Defining arguments
Defining a THROWS clause
Coding the function
Compiling and saving the function
Modifying user-defined functions
Using your functions
Working with User Events
About user events
User events and event IDs
Event ID names
Defining user events
Using a user event
Examples of user event scripts
Working with Structures
About structures
Deciding which kind you want
Defining structures
Modifying structures
Using structures
Referencing structures
Copying structures
Using structures with functions
Displaying and pasting structure information
Working with Windows
Working with Windows
About windows
Designing windows
Building windows
Types of windows
Main windows
Pop-up windows
Child windows
Response windows
MDI frames
About the Window painter
Building a new window
Creating a new window
Defining the window's properties
Using the General property page
Choosing the window size and position
Choosing the window pointer
Specifying window scrolling
Specifying toolbar properties
Adding controls
Adding nonvisual objects
Saving the window
Viewing your work
Previewing a window
Printing a window's definition
Writing scripts in windows
About events for windows and controls
About functions for windows and controls
About properties of windows and controls
Declaring instance variables
Examples of statements
Running a window
Using inheritance to build a window
Building two windows with similar definitions
Advantages of using inheritance
Instance variables in descendants
Control names in descendants
Working with Controls
About controls
Inserting controls in a window
Selecting controls
Defining a control's properties
Naming controls
About the default prefixes
Changing the default prefixes
Changing the name
Changing text
How text size is stored
Moving and resizing controls
Moving and resizing controls using the mouse
Moving and resizing controls using the keyboard
Aligning controls using the grid
Aligning controls with each other
Equalizing the space between controls
Equalizing the size of controls
Copying controls
Defining the tab order
Establishing the default tab order
Changing the window's tab order
Defining accelerator keys
Specifying accessibility of controls
Using the Visible property
Using the Enabled property
Choosing colors
Using the 3D look
Using the individual controls
CommandButton
Specifying Default and Cancel buttons
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
About inheritance
Creating new objects using inheritance
The inheritance hierarchy
Browsing the class hierarchy
Working with inherited objects
Using inherited scripts
Viewing inherited scripts
Extending a script
Overriding a script
Calling an ancestor script
Calling an ancestor function
Working with RibbonBar
Introduction to RibbonBar items
Creating a RibbonBar using RibbonBar Builder
Using the RibbonBar Builder
Creating a valid structure
Accessing the RibbonBar items via PowerScripts
Defining events for RibbonBar items
Packaging RibbonBar runtime files
RibbonBar layout tips
Displaying an MDI menu as a ribbon bar
Two approaches
Using RibbonView
Perfect path for effortless modernization
Zero coding is required
Enabling RibbonView
Configuring RibbonView
Rules
General rules
Images
Menu images
Guidelines for setting images for RibbonView
Troubleshooting: Menu icons not displaying in RibbonView
QuickAccessToolbar
Rules for QuickAccessToolbar
Toolbar properties
QuickAccessToolbar theme
Upgrade notes
Window size
Title bar
Functions, events, and properties
Functions and events
Properties
Runtime files
Theme
Using RibbonBar Converter
Exporting menu to XML file
mdirbb_1 object
Functions, events, and properties
One-way conversion
Runtime files and theme
Working with WebBrowser
What can WebBrowser support?
Choosing a WebView2 runtime version
Packaging WebBrowser
Configuring WebBrowser global settings
Triggering PowerBuilder events in JavaScript
Working with Menus and Toolbars
Menus and menu items
Using the Menu painter
Menu painter views
Menu styles
Building a new menu
Creating a new menu
Working with menu items
How menu items are named
Inserting menu items
Creating separation lines in menus
Duplicating menu items
Changing menu item text
Selecting menu items
Navigating in the menu
Moving menu items
Deleting menu items
Saving the menu
Defining the appearance and behavior of menu items
Setting General properties for menu items
Setting menu style properties for contemporary menus
Setting menu item style properties
Providing toolbars
How toolbars work
Adding toolbars to a window
Selecting a toolbar style
Setting toolbar properties
Toolbar style properties
Toolbar item display characteristics
Setting toolbar properties in the Window painter
Setting toolbar properties in the Application painter
Writing scripts for menu items
Menu item events
Using functions and variables
Referring to objects in your application
Using inheritance to build a menu
Using the inherited information
Inserting menu items in a descendant menu
Using menus in your applications
Adding a menu bar to a window
Displaying pop-up menus
Working with User Objects
About user objects
Class user objects
Visual user objects
Building user objects
About the User Object painter
Building a new user object
Creating a new user object
Building a custom class user object
Building a standard class user object
Building a custom visual user object
Building an external visual user object
Building a standard visual user object
Events in user objects
Saving a user object
Naming the user object
Using inheritance to build user objects
Using the inherited information
Using user objects
Using visual user objects
Using class user objects
Using global standard class user objects
Communicating between a window and a user object
Examples of user object controls affecting a window
Working with Databases
Managing the Database
Working with database components
Managing databases
Using the Database painter
Modifying database preferences
Logging your work
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
Specifying table properties
Specifying column extended attributes
Specifying additional properties for character columns
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
Retrieving data
Modifying data
Sorting rows
Filtering rows
Viewing row information
Importing data
Printing data
Saving data
Creating and executing SQL statements
Building and executing SQL statements
Creating stored procedures
Controlling comments
Entering SQL
Explaining SQL
Executing SQL
Customizing the editor
Controlling access to the current database
Using the ASA MobiLink synchronization wizard
What the wizard generates
Wizard options
Trying out MobiLink synchronization
Managing MobiLink synchronization on the server
Starting the MobiLink synchronization server
Using SQL Central
Working with Data Pipelines
About data pipelines
Defining a data pipeline
Piping extended attributes
Creating a data pipeline
Modifying the data pipeline definition
Choosing a pipeline operation
Dependency of modifications on pipeline operation
When execution stops
Whether rows are committed
Piping blob data
Changing the destination and source databases
Correcting pipeline errors
Saving a pipeline
Using an existing pipeline
Pipeline examples
Working with DataWindows
Defining DataWindow Objects
About DataWindow objects
DataWindow object examples
How to use DataWindow objects
Choosing a presentation style
Using the Tabular style
Using the Freeform style
Using the Grid style
Using the Label style
Using the N-Up style
Using the Group style
Using the Composite style
Using the Graph and Crosstab styles
Using the OLE 2.0 style
Using the RichText style
Using the TreeView style
Building a DataWindow object
Selecting a data source
Using Quick Select
Selecting a table
Selecting columns
Specifying sorting criteria
Specifying selection criteria
SQL expression examples
Using SQL Select
Selecting tables and views
Selecting columns
Displaying the underlying SQL statement
Joining tables
Using ANSI outer joins
Using retrieval arguments
Specifying selection, sorting, and grouping criteria
Using Query
Using External
Using Stored Procedure
Choosing DataWindow object-wide options
Generating and saving a DataWindow object
About the extended attribute system tables and DataWindow objects
Saving the DataWindow object
Naming the DataWindow object
Modifying an existing DataWindow object
Defining queries
Previewing the query
Saving the query
Modifying a query
What's next
Enhancing DataWindow Objects
Working in the DataWindow painter
Understanding the DataWindow painter Design view
The header band
The detail band
The summary and footer bands
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
Retrieving data
Modifying data
Viewing row information
Importing data into a DataWindow object
Using print preview
Printing data
Working in a grid DataWindow object
Saving data in an external file
Saving the data as PDF
Saving as PDF using NativePDF! method with PDFlib
Saving as PDF using the Distill! method with Ghostscript
Saving as XSL-FO
Saving the data in HTML Table format
Working with PSR files
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
Printing with newspaper-style columns
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
Modifying SQL SELECT statements
Modifying the result set
Storing data in a DataWindow object using the Data view
What happens at runtime
Retrieving data
Prompting for retrieval criteria in a DataWindow object
Retrieving rows as needed
Saving retrieved rows to disk
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
Computed columns versus computed fields
Defining a computed field in the DataWindow painter Design view
Adding buttons to a DataWindow object
Controlling the display of buttons in print preview and in printed output
Actions assignable to buttons in DataWindow objects
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
What you can do
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
Displaying and Validating Data
About displaying and validating data
Presenting the data
Validating data
About display formats
Working with display formats
Working with display formats in the Database painter
Working with display formats in the DataWindow painter
Defining display formats
Number display formats
String display formats
Date display formats
Time display formats
About edit styles
Working with edit styles
Working with edit styles in the Database painter
Working with edit styles in the DataWindow painter
Defining edit styles
The Edit edit style
The DropDownListBox edit style
The CheckBox edit style
The RadioButtons edit style
The EditMask edit style
The DropDownDataWindow edit style
The RichText edit style
The InkEdit edit style
Defining a code table
How code tables are implemented
How code tables are processed
Validating user input
About validation rules
Understanding validation rules
Working with validation rules
Defining validation rules
Defining a validation rule in the Database painter
Defining the expression
Using match values for character columns
Customizing the error message
Specifying initial values
Defining a validation rule in the DataWindow painter
Specifying the expression
Examples
How to maintain extended attributes
Filtering, Sorting, and Grouping Rows
Filtering rows
Sorting rows
Suppressing repeating values
Grouping rows
Using the Group presentation style
Defining groups in an existing DataWindow object
Specifying the grouping columns
Sorting the rows
Rearranging the DataWindow object
Adding summary statistics
Sorting the groups
Highlighting Information in DataWindow Objects
Highlighting information
Modifying properties when designing
Modifying properties at runtime
Modifying properties conditionally at runtime
Example 1: creating a gray bar effect
Example 2: rotating controls
Example 3: highlighting rows of data
Example 4: changing the size and location of controls
Supplying property values
Background.Color
Border
Brush.Color
Brush.Hatch
Color
Font.Escapement (for rotating controls)
Font.Height
Font.Italic
Font.Strikethrough
Font.Underline
Font.Weight
Format
Height
Pen.Color
Pen.Style
Pen.Width
Pointer
Protect
Timer_Interval
Visible
Width
X
X1, X2
Y
Y1, Y2
Specifying colors
Using Nested Reports
About nested reports
Creating a report using the Composite presentation style
Placing a nested report in another report
Placing a related nested report in another report
Placing an unrelated 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
About graphs
Parts of a graph
How data is represented
Organization of a graph
Types of graphs
Area, bar, column, and line graphs
Pie graphs
Scatter graphs
Three-dimensional graphs
Stacked graphs
Using graphs in applications
Using graphs in DataWindow objects
Placing a graph in a DataWindow object
Using the graph's Properties view
Changing a graph's position and size
Associating data with a graph
Specifying which rows to include in a graph
Specifying the categories
Specifying the values
Specifying the series
Examples
Using the Graph presentation style
Defining a graph's properties
Using the General page in the graph's Properties view
Sorting data for series and categories
Specifying text properties for titles, labels, axes, and legends
Specifying overlap and spacing
Specifying axis properties
Specifying a pointer
Using graphs in windows
Working with Crosstabs
About crosstabs
Two types of crosstabs
Creating crosstabs
Associating data with a crosstab
Specifying the information
Viewing the crosstab
Specifying more than one row or column
Previewing crosstabs
Enhancing crosstabs
Specifying basic properties
Modifying the data associated with the crosstab
Changing the names used for the columns and rows
Defining summary statistics
Using crosstab functions
Cross-tabulating ranges of values
Creating static crosstabs
Using property conditional expressions
Working with TreeViews
TreeView presentation style
Creating a new TreeView DataWindow
TreeView creation process
Creating a TreeView DataWindow
Adding and deleting TreeView levels
Selecting a tree node and navigating the tree
Sorting rows in a TreeView DataWindow
TreeView DataWindow Design view
Setting properties for the TreeView DataWindow
Setting general TreeView properties
Setting TreeView level properties
Setting detail band properties
TreeView DataWindow examples
Data Explorer sample
Data Linker sample
Exporting and Importing XML Data
About XML
Valid and well-formed XML documents
XML syntax
XML parsing
XML support in the DataWindow painter
The Export/Import Template view for XML
Creating templates
Saving templates
Header and Detail sections
Header section
Detail section
Editing XML templates
XML declaration
Document type declaration
Root element
Controls
DataWindow expressions
Attributes
Composite and nested reports
CDATA sections
Comments
Processing instructions
Exporting to XML
Setting data export properties
The Use Template property
Generating group headers
Formatting the exported XML
Exporting metadata
Selecting templates at runtime
Importing XML
Importing with a template
Example
Default data import
Example with no empty elements
Example with empty elements
Tracing import
Working with Rich Text
About rich text
Using the RichText presentation style
Creating the DataWindow object
Formatting for RichText objects within the DataWindow object
The whole RichText DataWindow
Selected text and paragraphs
Input fields
Pictures
Previewing and printing
Using the RichTextEdit control
Formatting keys and toolbars
Using OLE in a DataWindow Object
About using OLE in DataWindow objects
OLE objects and the OLE presentation style
Adding an OLE object to a DataWindow object
Using the OLE presentation style
Defining the OLE object
Specifying data for the OLE object
Previewing the DataWindow object
Activating and editing the OLE object
Changing the object in the control
Using OLE columns in a DataWindow object
Creating an OLE column
Running Your Application
Debugging and Running Applications
Overview of debugging and running applications
Debugging an application
Starting the debugger
Setting breakpoints
Running in debug mode
Examining an application at a breakpoint
Examining variable values
Watching variables and expressions
Monitoring the call stack
Examining objects in memory
Using the Source view
Using the Source Browser view
Using the Source History view
Stepping through an application
Debugging windows opened as local variables
Just-in-time debugging
Using the DEBUG preprocessor symbol
Breaking into the debugger when an exception is thrown
Running an application
Running the application
Handling errors at runtime
Tracing and Profiling Applications
About tracing and profiling an application
Collecting trace information
Tracing an entire application in PowerBuilder
Using a window
Collecting trace information using PowerScript functions
Analyzing trace information using profiling tools
Profiling Class View
Profiling Routine View
Profiling Trace View
Setting call aggregation preferences
Analyzing trace information programmatically
Analyzing performance with a call graph model
Using the BuildModel function to build a call graph model
Extracting information from the call graph model
Analyzing structure and flow using a trace tree model
Using BuildModel to build a trace tree model
Extracting information from the trace tree model
Accessing trace data directly
Using the TraceFile object
Generating a trace file without timing information
Creating Executables and Components
About building PowerBuilder targets
Using the Project painter
Creating a project
Using dynamic libraries
Attaching or embedding manifest files
Distributing resources
Distributing resources separately
Using PowerBuilder resource files
What happens at runtime
Working with an Application project
Creating an Application project
Defining an Application project
Tracing execution
Building a client/server application and dynamic libraries
How PowerBuilder builds the project
How PowerBuilder searches for objects
Which objects are copied to the executable file
Which objects are not copied to the executable file
Which objects are not copied to the dynamic libraries
How to include the objects that were not found
Listing the objects in a project
Building a client/server application with commands
Tutorial: Building your client/server application with commands
Task 1: Exporting the build file
Preparing the environment
Exporting the build file
Modifying the build file
About the build file
Getting source code from SVN, Git, or VSS
Merging PBLs
Executing additional commands
Task 2: Building with commands
Preparing the environment
Running the command line tool
Verifying if PBAutoBuild is successful
Integrating with Jenkins
Working with a PowerClient project
Configuring a server profile
Uploading the app launcher and runtime files
About cloud app launcher
Customizing and uploading cloud app launcher
Creating a PowerClient project
Defining a PowerClient project
Application page
Security page
Build page
Deploy page
Building and deploying a PowerClient project
Building and deploying the PowerClient project with commands
Running the PowerClient project
Debugging the PowerClient project
Packaging the PowerClient project
Undeploying the PowerClient project
Uninstalling the PowerClient project
Changing the deployed app via CustomizeDeploy.dll
Prerequisites
Changing external files
Ignoring server certificate errors
Supporting cookie validation
Rolling back to an earlier version of app
Tutorial 1: Deploying your first PowerClient project
Tutorial 2: Building your PowerClient project with commands
Task 1: Exporting the build file
Preparing the environment
Creating a launcher package
Exporting the build file
Modifying the build file
About the build file
Getting source code from SVN, Git, or VSS
Merging PBLs
Executing additional commands
Task 2: Building with commands
Preparing the environment
Running the command line tool
Verifying if PBAutoBuild is successful
Integrating with Jenkins
Working with a PowerServer project
Working with a .NET DataStore project
Overview
Creating a .NET DataStore project
Creating a database connection
Defining a .NET DataStore project
Project page
Converter page
Scaffolding page
Security page
Configuring the global settings
Generating and building a .NET DataStore project
Running a .NET DataStore project
Editing or publishing a .NET DataStore project
Calling APIs from PowerScript
Building proxies and .NET targets
PowerBuilder Utilities
PBAutoBuild
About PBAutoBuild
Installing PBAutoBuild
Software requirements
System requirements
Running PBAutoBuild
PBAutoBuild supported parameters
/f and related parameters
/pbc, /c, and related parameters
/pbc, /d, and related parameters
/p parameter
/h parameter
PowerBuilder Compiler (obsolete)
OrcaScript
About OrcaScript
OrcaScript Commands
Usage notes for OrcaScript commands and parameters
Usage notes for OrcaScript commands with SVN/Git
Appendixes
Appendix A. The Extended Attribute System Tables
About the extended attribute system tables
The extended attribute system tables
Edit style types for the PBCatEdt table
CheckBox edit style (code 85)
RadioButton edit style (code 86)
DropDownListBox edit style (code 87)
DropDownDataWindow edit style (code 88)
Edit edit style (code 89)
Edit Mask edit style (code 90)
Appendix B. The PB.INI File
About the initialization file
PB.INI settings
Appendix C. Variables in application object
Search Highlighter (On/Off)
