Powerbuilder Documentation 9.0

Powerbuilder Documentation 9.0

Defining queries – PB Docs 90

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…

Working with database components – PB Docs 90

Working with database components A database is an electronic storage place for data. Databases are designed to ensure that data is valid and consistent and that it can be accessed, modified, and shared. A database management system (DBMS) governs the activities of a database and enforces rules that ensure data integrity. A relational DBMS stores…

Working with validation rules – PB Docs 90

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…

Chapter 23 Highlighting Information in DataWindow Objects – PB Docs 90

Chapter 23 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…

Modifying general DataWindow object properties – PB Docs 90

Modifying general DataWindow object properties This section describes the general DataWindow object properties that you can modify. Changing the DataWindow object style The general style properties for a DataWindow object include: The unit of measure used in the DataWindow object A timer interval for events in the DataWindow object A background color for the DataWindow…