Using toolbars – PB Docs 90
Using toolbars Toolbars provide buttons for the most common tasks in PowerBuilder. You can move (dock) toolbars, customize them, and create your own. Toolbar basics PowerBuilder uses three toolbars: the PowerBar, PainterBar, and StyleBar: This toolbar Has buttons for And (unless hidden) displays PowerBar Opening painters and tools Always PainterBar Performing tasks in the current…
Working with edit styles – PB Docs 90
Working with edit styles You work with edit styles in the Database painter and DataWindow painter. What you do in the Database painter In the Database painter, you can: Create, modify, and delete named edit styles The edit styles are stored in the extended attribute system tables. Once you define an edit style, it can…
Defining edit styles – PB Docs 90
Defining edit styles This section describes how to specify each type of edit style. The Edit edit style By default, columns use the Edit edit style, which displays data in an edit control. You can customize the appearance and behavior of the edit control by modifying a column’s Edit edit style. To do so, select…
Defining a code table – PB Docs 90
Defining a code table To reduce storage needs, you frequently want to store short, encoded values in the database. But these encoded values may not be meaningful to users. To make DataWindow objects easy to use, you can define code tables. Each row in a code table is a pair of corresponding values: a display…
About validation rules – PB Docs 90
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. One way to do this is through validation rules. You usually define validation rules in the Database painter. To use a validation rule, you associate it with a…
Grouping rows – PB Docs 90
Grouping rows You can group related rows together and, optionally, calculate statistics for each group separately. For example, you might want to group employee information by department and get total salaries for each department. How groups are defined Each group is defined by one or more DataWindow object columns. Each time the value in a…
Working with validation rules – PB Docs 90
Working with validation rules You work with validation rules in the Database painter and DataWindow painter. What you do in the Database painter In the Database painter, you can: Create, modify, and delete named validation rules The validation rules are stored in the extended attribute system tables. Once you define a validation rule, it can…
Defining validation rules – PB Docs 90
Defining validation rules Typically, you define validation rules in the Database painter, because validation rules are properties of the data itself. Once defined in the Database painter, the rules are used by default each time the column is placed in a DataWindow object. You can also define a validation rule in the DataWindow painter that…
Summary of maintaining the entities – PB Docs 90
Summary of maintaining the entities PowerBuilder provides facilities you can use to create, modify, and delete display formats, edit styles, and validation rules independently of their association with columns. The following procedure summarizes how you do this. To maintain display formats, edit styles, and validation rules: Open the Database painter. Select View>Extended Attributes. The Extended…
Chapter 22 Filtering, Sorting, and Grouping Rows – PB Docs 90
Chapter 22 Filtering, Sorting, and Grouping Rows About this chapter This chapter describes how you can customize your DataWindow object by doing the following in the DataWindow painter: Defining filters to limit which of the retrieved rows are displayed in the DataWindow object Sorting rows after they have been retrieved from the database Displaying the…