Example 1: creating a gray bar effect – PB Docs 150
Example 1: creating a gray bar effect The following DataWindow object shows alternate rows with a light gray bar. The gray bars make it easier to track data values across the row: To create the gray bar effect: Add a rectangle control to the detail band and size it so that it surrounds the controls…
Equalizing the size of controls in a DataWindow object – PB Docs 150
Equalizing the size of controls in a DataWindow object Suppose you have several controls in a DataWindow object and want their sizes to be the same. You can accomplish this manually or by using the Format menu. To equalize the size of controls in a DataWindow object: Select the control whose size is correct. Press…
Specifying sorting criteria – PB Docs 150
Specifying sorting criteria In the grid at the bottom of the Quick Select dialog box, you can specify if you want the retrieved rows to be sorted. As you specify sorting criteria, PowerBuilder builds an ORDER BY clause for the SELECT statement. To sort retrieved rows on a column: Click in the Sort row for…
Filtering, Sorting, and Grouping Rows – PB Docs 150
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 rows in…
Highlighting Information in DataWindow Objects – PB Docs 150
Highlighting Information in DataWindow Objects About this chapter This chapter describes how you modify the way information displays in DataWindow objects and reports based on the conditions you specify. The conditions are usually related to data values, which are not available until runtime. Contents Topic Highlighting information Modifying properties conditionally at runtime Supplying property values…
What happens at runtime – PB Docs 150
What happens at runtime Data stored in a DataWindow object is stored within the actual object itself, so when a window opens showing such a DataWindow, the data is already there. There is no need to issue Retrieve to get the data. PowerBuilder never retrieves data into a drop-down DataWindow that already contains data. For…
Specifying the table to update – PB Docs 150
Specifying the table to update Each DataWindow object can update one table, which you select from the Table to Update box in the Specify Update Properties dialog box. Document get from Powerbuilder help Thank you for watching.
Understanding validation rules – PB Docs 150
Understanding validation rules Validation rules are criteria that a DataWindow object uses to validate data entered into a column by users. They are PowerBuilder-specific and therefore not enforced by the DBMS. Validation rules assigned in the Database painter are used by default when you place columns in a DataWindow object. You can override the default…
Which references are displayed – PB Docs 150
Which references are displayed The Browser displays the following types of references when the Application object is expanded. Objects referenced in painters These are examples of objects referenced in painters: If a menu is associated with a window in the Window painter, the menu displays when the window is expanded. If a DataWindow object is…
About windows – PB Docs 150
About windows Windows form the interface between the user and a PowerBuilder application. Windows can display information, request information from a user, and respond to the user’s mouse or keyboard actions. A window consists of: Properties that define the window’s appearance and behavior For example, a window might have a title bar or a minimize…