Manipulating data – PB Docs 70
Manipulating data As you work on the database, you will often want to look at existing data or create some data for testing purposes. You will also want to test display formats, validation rules, and edit styles on real data. PowerBuilder provides the Data Manipulation view for such purposes. In this painter, you can: Retrieve…
Working with keys – PB Docs 70
Working with keys If your DBMS supports primary and foreign keys, you can work with the keys in PowerBuilder. Why you should use keys If your DBMS supports them, you should use primary and foreign keys to enforce the referential integrity of your database. That way you can rely on the DBMS to make sure…
Administering the database – PB Docs 70
Administering the database Administering your databases with the Database painter means having the ability to: Create SQL statements to send to the DBMS for immediate execution Control access to the current database Creating and executing SQL statements The Database painter’s Interactive SQL view is a SQL editor in which you can enter and execute SQL…
Working with indexes – PB Docs 70
Working with indexes You can create as many single- or multi-valued indexes for a database table as you need, and you can drop indexes that are no longer needed. Update limitation You can update a table in a DataWindow object only if it has a unique index or primary key. Creating an index In Adaptive…
About DataWindow objects – PB Docs 70
About DataWindow objects A DataWindow object is an object that you use to retrieve, present, and manipulate data from a relational database or other data source (such as an Excel worksheet or dBASE file). DataWindow objects have knowledge about the data they are retrieving. You can specify display formats, presentation styles, and other data properties…
Customizing keyboard shortcuts – PB Docs 70
Customizing keyboard shortcuts You can associate your own keyboard shortcuts with PowerBuilder menu items. For example, if you’ve used another debugger, you may be accustomed to using specific function keys or key combinations to step into and over functions. So you may want to create keyboard shortcuts to associate actions in PowerBuilder’s Debugger with the…
About reports – PB Docs 70
About reports Reports provide many ways for you to present data. You may want a tabular report with rows and columns of information. Sometimes a graph or a crosstab is a better way to present the data. A PowerBuilder report can also be mailing labels or many reports nested together on the same page. Freeform…
Using online Help – PB Docs 70
Using online Help PowerBuilder has online Help that provides both reference and task-oriented information. How to access Help You can get Help in any of these ways: Approach What it does Use the Help menu on the menu bar Displays the Help contents, the What’s New in PowerBuilder Help, or Help for the current painter…
Adding controls to a DataWindow object – PB Docs 70
Adding controls to a DataWindow object This section describes adding controls to enhance your DataWindow object. Adding columns to a DataWindow object You can add columns that are included in the data source to a DataWindow object. When you first create a DataWindow object, each of the columns in the data source is automatically placed…
About managing databases – PB Docs 70
About managing databases PowerBuilder supports many database management systems (DBMSs). For the most part, you work the same way in PowerBuilder for each DBMS. But because each DBMS provides some unique features (which PowerBuilder makes use of), there are some issues that are specific to a particular DBMS. For complete information about using your DBMS,…