Powerbuilder Documentation 15.0

Powerbuilder Documentation 15.0

Naming controls in a DataWindow object – PB Docs 150

Naming controls in a DataWindow object You use names to identify columns and other controls in validation rules, filters, PowerScript functions, and DataWindow expression functions. The DataWindow painter automatically generates names for all controls in a DataWindow object. To name columns, labels, and headings, the DataWindow painter uses database and extended attribute information. To name…

Wizard options – PB Docs 150

Wizard options Except for the object name settings, Table 16-8 lists the ASA MobiLink Synchronization wizard options. Table 16-8: ASA MobiLink Synchronization wizard options Option Description Destination library Lets you select the target PBL file where you want to generate the MobiLink synchronization objects. Desktop database connection Lets you select a PowerBuilder database profile or…

Setting colors in a DataWindow object – PB Docs 150

Setting colors in a DataWindow object You can set different colors for each element of a DataWindow object to enhance the display of information. To set a solid background color in a DataWindow object: Position the mouse on an empty spot in the DataWindow object, display the pop-up menu, and select Properties. On the Background…

Using an existing pipeline – PB Docs 150

Using an existing pipeline If you save a pipeline, you can modify and execute it any time. You can also pipe data that might have changed since the last pipeline execution or pipe data to other databases. To use an existing pipeline: Click the Open button in the PowerBar. In the Open dialog box, select…

Defining queries – PB Docs 150

Defining queries A query is a SQL SELECT statement created in the Query painter and saved with a name so that it can be used repeatedly as the data source for a DataWindow object. Queries save time, because you specify all the data requirements just once. For example, you can specify the columns, which rows…

Using SQL Select – PB Docs 150

Using SQL Select In specifying data for a DataWindow object, you have more options for specifying complex SQL statements when you use SQL Select as the data source. When you choose SQL Select, you go to the SQL Select painter, where you can paint a SELECT statement that includes the following: More than one table…

About controlling updates – PB Docs 150

About controlling updates When PowerBuilder generates the basic DataWindow object, it defines whether the data is updatable by default as follows: If the DataWindow object contains columns from a single table and includes that table’s key columns, PowerBuilder defines all columns as updatable and specifies a nonzero tab order for each column, allowing users to…

Defining a code table – PB Docs 150

Defining a code table To reduce storage needs, frequently you might want to store short, encoded values in the database, but these encoded values might not be meaningful to users. To make DataWindow objects easy to use, you can define code tables. Each row in a code table is a pair of corresponding values: a…

Background.Color – PB Docs 150

Background.Color Description Setting for the background color of a control. In the painter Background Color on the Background page or Font page in the Properties view. Value A number that specifies the control’s background color. For information on specifying colors, see “Specifying colors”. The background color of a line is the color that displays between…

Defining a data pipeline – PB Docs 150

Defining a data pipeline When you use the Data Pipeline painter to create a pipeline, you define the: Source database Destination database Source of data Pipeline operation Destination table After you create a pipeline, you can execute it immediately. If you want, you can also save it as a named object to use and reuse….