Powerbuilder Documentation 12.5

Powerbuilder Documentation 12.5

Using the Label style – PB Docs 125

Using the Label style The Label presentation style shows data as labels. With this style you can create mailing labels, business cards, name tags, index cards, diskette labels, file folder labels, and many other types of labels. Mailing labels Business cards Name tags Specifying label properties If you choose the Label style, you are asked…

Modifying database preferences – PB Docs 125

Modifying database preferences To modify database preferences, select Design>Options from the menu bar. Some preferences are specific to the database connection; others are specific to the Database painter. Preferences on the General property page The Connect To Default Profile, Shared Database Profiles, Keep Connection Open, Use Extended Attributes, and Read Only preferences are specific to…

Creating stored procedures – PB Docs 125

Creating stored procedures You can use the Interactive SQL view to create stored procedures or triggers, but make sure that the Database painter’s SQL statement terminator character is not the same as the terminator character used in the stored procedure language of your DBMS. About the statement terminator By default, PowerBuilder uses the semicolon as…

Choosing a pipeline operation – PB Docs 125

Choosing a pipeline operation When PowerBuilder pipes data, what happens in the destination database depends on which pipeline operation you choose in the Options drop-down list at the top of the workspace. Table 17-3: Effect of pipeline operations on the destination database Pipeline operation Effect on destination database Create – Add Table A new table…

Managing the Database – PB Docs 125

Managing the Database About this chapter This chapter describes how to manage a database from within PowerBuilder. Contents Topic 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…

Starting PowerBuilder with an open workspace – PB Docs 125

Starting PowerBuilder with an open workspace When you start PowerBuilder, you might want to resume work on an existing project. You can have PowerBuilder open the workspace that you used last, and even open the painters you had open, with the last Script view you touched open at the code you were working on. Document…

Using zoom in the DataWindow painter – PB Docs 125

Using zoom in the DataWindow painter You can zoom the display in and out in four views in the DataWindow painter: the Design view, Preview view, Data view, and Column Specifications view. For example, if you are working with a large DataWindow object, you can zoom out the Design view so you can see all…

Using global standard class user objects – PB Docs 125

Using global standard class user objects Five of the standard class user object types are inherited from predefined global objects used in all PowerBuilder applications: Transaction (SQLCA) DynamicDescriptionArea (SQLDA) DynamicStagingArea (SQLSA) Error Message Replacing the built-in global object If you want your standard class user object to replace the built-in global object, you tell PowerBuilder…

Naming controls in a DataWindow object – PB Docs 125

Naming controls in a DataWindow object You use names to identify columns and other controls in validation rules, filters, PowerScript functions, and DataWindow expression functions. The DataWindow painter automatically generates names for all controls in a DataWindow object. To name columns, labels, and headings, the DataWindow painter uses database and extended attribute information. To name…

Copying controls – PB Docs 125

Copying controls You can copy controls within a window or to other windows. All properties of the control, as well as all of its scripts, are copied. You can use this technique to make a copy of an existing control and change what you want in the copy. To copy a control: Select the control….