Controlling access to the current database – PB Docs 120
Controlling access to the current database The Database painter’s Design menu provides access to a series of dialog boxes you can use to control access to the current database. In some DBMSs, for example, you can assign table access privileges to users and groups. Which menu items display on the Design menu and which dialog…
Chapter 18 Defining DataWindow Objects – PB Docs 120
Chapter 18 Defining DataWindow Objects About this chapter The applications you build are centered around your organization’s data. This chapter describes how to define DataWindow objects to display and manipulate the data. Contents Topic About DataWindow objects Choosing a presentation style Building a DataWindow object Selecting a data source Using Quick Select Using SQL Select…
Chapter 16 Managing the Database – PB Docs 120
Chapter 16 Managing the Database About this chapter This chapter describes how to manage a database from within PowerBuilder. Contents Topic Working with database components Managing databases Using the Database painter Creating and deleting a SQL Anywhere database Working with tables Working with keys Working with indexes Working with database views Manipulating data Creating and…
Retrieving data – PB Docs 120
Retrieving data In a DataWindow object, you can prompt for retrieval criteria, retrieve rows as needed, and save retrieved rows to disk. Prompting for retrieval criteria in a DataWindow object You can define your DataWindow object so that it always prompts for retrieval criteria just before it retrieves data. PowerBuilder allows you to prompt for…
Using Query – PB Docs 120
Using Query When you choose Query as the data source, you select a predefined SQL SELECT statement (a query) as specifying the data for your DataWindow object. To define the data using Query: While using any of the DataWindow wizards, click Query in the Choose Data Source dialog box, and click Next. The Select Query…
Working with validation rules – PB Docs 120
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…
Using stored procedures to update the database – PB Docs 120
Using stored procedures to update the database Updates to the database can be performed using stored procedures. Why use stored procedures? The DataWindow control submits updates to the database by dynamically generating INSERT, DELETE, and UPDATE SQL statements after determining the status of each row in the DataWindow object. You can also define procedural SQL…
Working with a DataStore – PB Docs 120
Working with a DataStore To use a DataStore, you first need to create an instance of the DataStore object in a script and assign the DataWindow object to the DataStore. Then, if the DataStore is intended to retrieve data, you need to set the transaction object for the DataStore. Once these setup steps have been…
Target types – PB Docs 120
Target types This section describes each of the targets you can build. Application targets There are three wizards for creating application targets: Application Target wizard Template Application Target wizard Existing Application Target wizard Application Target wizard You use the Application Target wizard to create a new PowerScript-based Application object and the library containing it. You…
Making database connections – PB Docs 120
Making database connections The connection process The Web ActiveX and Transaction Object controls make database connections using JDBC. Their Java classes interact with the Java classes of the database vendor’s JDBC interface. The vendor’s classes interact with the database. JDBC driver from a database vendor The classes for the JDBC database driver you plan to…