Working with display formats – PB Docs 70
Working with display formats You can use display formats to customize the display of column data in a DataWindow object. Display formats are masks in which certain characters have special significance. For example, you can display currency values preceded by a dollar sign, show dates with month names spelled out, and use a special color…
Saving retrieved rows to disk – PB Docs 70
Saving retrieved rows to disk If you want to maximize the amount of memory available to PowerBuilder and other running applications, you can have PowerBuilder save retrieved data on your hard disk in a temporary file rather than keep the data in memory. PowerBuilder swaps rows of data from the temporary file into memory as…
Working with edit styles – PB Docs 70
Working with edit styles You can define edit styles for columns. Edit styles specify how column data is presented in DataWindow objects. Unlike display formats, edit styles don’t only affect the display of data; they also affect how users interact with the data during execution. Once you define an edit style, it can be used…
Working with validation rules – PB Docs 70
Working with 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…
Example 2: rotating controls – PB Docs 70
Example 2: rotating controls The following DataWindow object shows column headers rotated 45 degrees. To rotate each of these three text controls, you would select Properties from the popup menu for each control and make an entry by clicking the button next to the Escapement property on the Font property page. Specifying rotation To specify…
Example 3: highlighting rows of data – PB Docs 70
Example 3: highlighting rows of data The following DataWindow object is an employee phone list. Out-of-state (not in Massachusetts) employees are shown in bold and preceded by two asterisks (**): This DataWindow object uses newspaper columns. To understand how to create this DataWindow object without highlighting data, see “Printing with newspaper-style columns”. In the Design…
Example 4: changing the size and location of controls – PB Docs 70
Example 4: changing the size and location of controls The following DataWindow object shows a rectangle and a line that change size and location if the current row contains data for a customer from the state of New York. The City and State columns also change location, but the discussion will focus on the rectangle…
Supplying property values – PB Docs 70
Supplying property values Each property has its own set of property values that you can use to specify for the true and false conditions in your If expression. Usually you specify a number to indicate what you want. For example, if you are working with the Border property, you use the number 0, 1, 2,…
Specifying colors – PB Docs 70
Specifying colors You specify a color by specifying a number that represents the color. You can specify the number explicitly or by using an expression that includes the RGB (r, g, b) function. For the numbers and expressions that specify common colors, see the table below. How the number is calculated The formula for combining…
About nested reports – PB Docs 70
About nested reports A nested report is a report in another report. There are two ways to create reports that have nested reports: Create a composite report using the Composite presentation style Place a nested report in another report About creating a composite report You can choose the Composite presentation style to create a new…