String display formats – PB Docs 150
String display formats String display formats can have two sections. The first is required and contains the format for strings; the second is optional and specifies how to represent NULLs:
|
1 |
string-format;null-format |
In a string format mask, each at-sign (@) represents a character in the string and all other characters represent themselves. Special characters for string…
Joining tables – PB Docs 150
Joining tables If the DataWindow object will contain data from more than one table, you should join the tables on their common columns. If you have selected more than one table, PowerBuilder joins columns according to whether they have a key relationship: Columns with a primary/foreign key relationship are joined automatically. Columns with no key…
Specifying pointers for a DataWindow object – PB Docs 150
Specifying pointers for a DataWindow object Just as with colors, you can specify different pointers to use when the mouse is over a particular area of the DataWindow object. For example, you might want to change the pointer when the mouse is over a column whose data cannot be changed. To change the mouse pointer…
Adding reports to a DataWindow object – PB Docs 150
Adding reports to a DataWindow object You can nest reports (nonupdatable DataWindow objects) in a DataWindow object. For information on nesting reports, see Chapter 25, “Using Nested Reports .” Document get from Powerbuilder help Thank you for watching.
Specifying the WHERE clause for update/delete – PB Docs 150
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…
Customizing toolbars – PB Docs 150
Customizing toolbars You can customize toolbars with PowerBuilder buttons and with buttons that invoke other applications, such as a clock or text processor. Adding, moving, and deleting buttons You can add, move, and delete buttons in any toolbar. To add a button to a toolbar: Position the pointer on the toolbar and display the pop-up…
Font.Italic – PB Docs 150
Font.Italic Description A number that specifies whether the text should be italic. In the painter Italic on the Font page in the Properties view. Value Values are: 0—Not italic 1—Italic Example The following statements are specified for the Font.Italic, Font.Underline, and Font.Weight properties, respectively. If the employee has health insurance, the employee’s information displays in…
Filtering rows – PB Docs 150
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….
Positioning controls in a DataWindow object – PB Docs 150
Positioning controls in a DataWindow object Table 20-3 shows the properties for each control in a DataWindow object that determine how it is positioned within the DataWindow object. Table 20-3: Position properties for controls in a DataWindow object Property Meaning Background Control is behind other controls. It is not restricted to one band. This is…
Working in a grid DataWindow object – PB Docs 150
Working in a grid DataWindow object If you are viewing a grid-style DataWindow object in the Preview view, you can make the following changes. Whatever you do in the Preview view is reflected in the Design view: Resize columns Reorder columns Split the display into two horizontal scrolling regions You can use this feature to…