Introduction to PowerBuilder

Invoking Database Painter

To invoke a database painter, click the database icon on the PowerBar. When you invoke it for the first time, PowerBuilder automatically connects to the current version of the example database (for version 5.0, it is psdemodb.db). If the database is not running, PowerBuilder automatically starts the database engine and connects to it. If you are not invoking the database painter for the first time, it will connect to the database that you connected in the last session.

Once the database painter is open, PowerBuilder displays all the tables that are available in the connected database. The following picture displays the table and the view names which you see when connected to the example database. If you would like to see system tables, you need to check the "Show System Tables" checkbox.

Recall that objects you create in PowerBuilder are stored in PowerBuilder library. The exception to that are the things you create in the database painter --such as tables, indexes, views, etc.. They  don't get stored in the PowerBuilder library, instead they are stored in the connected database.

For the Product Management System application, we need few tables. If you create tables right away it will create in the example database. Let us store all the tables you create in a separate database. That means we need to create a database.

Home	Previous Lesson: Introduction Next Lesson: Creating a Database