Defining print specifications for a DataWindow object – PB Docs 2021
Defining print specifications for a DataWindow object Contents Printing with newspaper-style columns When you are satisfied with the look of the DataWindow object, you can define its print specifications. To define print specifications for a DataWindow object In the DataWindow painter, select Properties from the DataWindow object’s pop-up menu. In the Units box on the…
Specifying the unique key columns – PB Docs 2021
Specifying the unique key columns The Unique Key Columns box in the Specify Update Properties dialog box specifies which columns PowerBuilder uses to identify a row being updated. PowerBuilder uses the column or columns you specify here as the key columns when generating the WHERE clause to update the database (as described below): The key…
Modifying properties when designing – PB Docs 2021
Modifying properties when designing You define the appearance and behavior of controls in DataWindow objects in the DataWindow painter. As you do that, you are specifying the controls’ properties. For example, when you place a border around a column, you are setting that column’s Border property. In most cases, the appearance and behavior of controls…
Specifying properties of a grid DataWindow object – PB Docs 2021
Specifying properties of a grid DataWindow object In grid DataWindow objects, you can specify: When grid lines are displayed How users can interact with the DataWindow object at runtime To specify basic grid DataWindow object properties Position the mouse pointer on the background in a grid DataWindow object, display the pop-up menu, and select Properties….
Adding table blob controls to a DataWindow object – PB Docs 2021
Adding table blob controls to a DataWindow object Use the table blob control to add rich text, image, or XPS blobs to the DataWindow object. To add a table blob control to a DataWindow object Select Insert>Control>Table Blob from the menu bar. Click where you want to place the table blob. In the Database Binary/Text…
Working with edit styles in the DataWindow painter – PB Docs 2021
Working with edit styles in the DataWindow painter An edit style you assign to a column in the Database painter is used by default when you place the column in a DataWindow object. You can override the edit style in the DataWindow painter by choosing another edit style from the extended attribute system tables or…
Sorting the groups – PB Docs 2021
Sorting the groups You can sort the groups in a DataWindow object. For example, in a DataWindow object showing employee information grouped by department, you might want to sort the departments (the groups) by total salary. Typically, this involves aggregate functions, as described in Adding summary statistics. In the department salary example, you would sort…
Rearranging the DataWindow object – PB Docs 2021
Rearranging the DataWindow object When you create a group, PowerBuilder creates two new bands for each group: A group header band A group trailer band The bar identifying the band contains: The number of the group The name of the band The name of each column that defines the group An arrow pointing to the…
Sorting the rows – PB Docs 2021
Sorting the rows PowerBuilder does not sort the data when it creates a group. Therefore, if the data source is not sorted, you must sort the data by the same columns (or expressions) specified for the groups. For example, if you are grouping by dept_name then state, select Rows>Sort from the menu bar and specify…
Adding OLE controls to a DataWindow object – PB Docs 2021
Adding OLE controls to a DataWindow object You can add the following to a DataWindow object: A column that contains a database binary large object (a blob object) using OLE 2.0 OLE 2.0 objects For information on using OLE in a DataWindow object, see Using OLE in a DataWindow Object. Document get from Powerbuilder help…