Introduction to PowerBuilder

Creating a Database

To create a new database, select "File/Create Database..." from the menu and provide name 'product'  when prompted.

PowerBuilder automatically supplies the User ID as 'DBA' and Password as 'SQL' (remember, each asterisk takes the place of a letter in the Password field). Later, we'll see how you can set up users and permissions for a database, but for now let's enjoy the power of a Database Administrator. PowerBuilder also generates the necessary information to start SQL Anywhere database engine by placing it in the Start command box.

You can click on the More>> button to identify other database specific options and you can also check the Prompt for Password during Connect box at this stage. This option allows you to force the user to type in the password each time they connect to the database. During development, it is a good idea to disable this feature, so click on the OK button and we'll move on.

Home	Previous Lesson: Invoking Database Painter Next Lesson: Creating 'units' Table