Rebuilding workspaces and targets – PB Docs 105
Rebuilding workspaces and targets When you make modifications to a target and need to update one or more libraries, you should use a rebuild option to update all the library objects in the correct sequence. Working with targets To see the pop-up menu that lets you perform operations on a target such as search, build,…
TreeView DataWindow samples – PB Docs 105
TreeView DataWindow samples This section provides you with two samples that demonstrate use of the TreeView DataWindow. What the samples do The two TreeView DataWindow samples are: Data Explorer The Data Explorer uses a TreeView DataWindow to display sales-related data in a Windows Explorer-like interface and allows users to update the data. Data Linker The…
Defining user-defined functions – PB Docs 105
Defining user-defined functions Although you define global functions in the Function painter and object-level functions in the painter for a specific object, in both cases you define and code the function in a Script view. When you add a new function, a Prototype window displays above the script area in the Script view. The fields…
Using the RichText presentation style – PB Docs 105
Using the RichText presentation style The RichText presentation style allows you to combine input fields that represent database columns with formatted text. This presentation style is useful for display-only reports, especially mail-merge documents. However, if you want to use the RichText DataWindow object for data entry, you can specify validation rules and display formats for…
Specifying update when key is modified – PB Docs 105
Specifying update when key is modified The Key Modification property determines the SQL statements PowerBuilder generates whenever a key column—a column you specified in the Unique Key Columns box—is changed. The options are: Use DELETE then INSERT (default) Use UPDATE How to choose a setting Consider the following when choosing the Key Modification setting: If…
Storing data in a DataWindow object using the Data view – PB Docs 105
Storing data in a DataWindow object using the Data view Usually you retrieve data into a DataWindow object from the database, because the data is changeable and you want the latest information. However, sometimes the data you display in a DataWindow object never changes (as in a list of states or provinces), and sometimes you…
Working with validation rules – PB Docs 105
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…
About crosstabs – PB Docs 105
About crosstabs Cross tabulation is a useful technique for analyzing data. By presenting data in a spreadsheet-like grid, a crosstab lets users view summary data instead of a long series of rows and columns. For example, in a sales application you might want to summarize the quarterly unit sales of each product. In PowerBuilder, you…
Sorting rows – PB Docs 105
Sorting rows You can use an ORDER BY clause in the SQL SELECT statement for the DataWindow object to sort the data that is retrieved from the database. If you do this, the DBMS itself does the sorting and the rows are brought into PowerBuilder already sorted. However, you might want to sort the rows…
Chapter 14 Working with Menus and Toolbars – PB Docs 105
Chapter 14 Working with Menus and Toolbars About this chapter By adding customized menus and toolbars to your applications, you can make it easy and intuitive for your users to select commands and options. This chapter describes how to define and use menus and toolbars. Contents Topic Menus and menu items Using the Menu painter…