About user-defined functions – PB Docs 105
About user-defined functions The PowerScript language has many built-in functions, but you may find that you need to code the same procedure over and over again. For example, you may need to perform a certain calculation in several places in an application or in different applications. In such a situation, create a user-defined function to…
About rich text – PB Docs 105
About rich text Rich text format (RTF) is a standard for specifying formatting instructions and document content in a single ASCII document. An editor that supports rich text format interprets the formatting instructions and displays formatted content. If you look at rich text in a plain ASCII editor, you see complex instructions that are not…
Specifying the WHERE clause for update/delete – PB Docs 105
Specifying the WHERE clause for update/delete Sometimes multiple users are accessing the same tables at the same time. In these situations, you need to decide when to allow your application to update the database. If you allow your application to always update the database, it could overwrite changes made by other users: You can control…
Modifying general DataWindow object properties – PB Docs 105
Modifying general DataWindow object properties This section describes the general DataWindow object properties that you can modify. Changing the DataWindow object style The general style properties for a DataWindow object include: The unit of measure used in the DataWindow object A timer interval for events in the DataWindow object A background color for the DataWindow…
About validation rules – PB Docs 105
About validation rules When users enter data in a DataWindow object, you want to be sure the data is valid before using it to update the database. Validation rules provide one way to do this. You usually define validation rules in the Database painter. To use a validation rule, you associate it with a column…
Chapter 27 Working with Crosstabs – PB Docs 105
Chapter 27 Working with Crosstabs About this chapter This chapter describes how to build crosstabs. Contents Topic About crosstabs Creating crosstabs Associating data with a crosstab Previewing crosstabs Enhancing crosstabs Document get from Powerbuilder help Thank you for watching.
Filtering rows – PB Docs 105
Filtering rows You can use WHERE and HAVING clauses and retrieval arguments in the SQL SELECT statement for the DataWindow object to limit the data that is retrieved from the database. This reduces retrieval time and space requirements at runtime. However, you may want to further limit the data that displays in the DataWindow object….
About inheritance – PB Docs 105
About inheritance One of the most powerful features of PowerBuilder is inheritance. It enables you to build windows, user objects, and menus that derive from existing objects. Using inheritance has a number of advantages: When you change an ancestor object, the changes are reflected in all the descendants. You do not have to make manual…
Working with inherited objects – PB Docs 105
Working with inherited objects This section describes: Working in a descendent object Working in an ancestor object Resetting properties in a descendant Working in a descendent object You can change descendent objects to meet specialized needs. For example, you can: Change properties of the descendent object Change properties of inherited controls in the object Add…
Using the Database painter – PB Docs 105
Using the Database painter To open the Database painter, click the Database button in the PowerBar. About the painter Like the other PowerBuilder painters, the Database painter contains a menu bar, customizable PainterBars, and several views. All database-related tasks that you can do in PowerBuilder can be done in the Database painter. Views in the…