Progress
Application Development
Environment — Getting Started
Creating and Connecting To the Sports2000 Database
Before running or assembling the sample application described in this chapter, you must create a copy of the Sports2000 database and connect to it.
To complete this task, you use the Data Dictionary tool. The Data Dictionary tool is part of the Application Development Environment (ADE) and is used to create and connect to databases and to edit the definitions of tables, fields, indexes, and other database-related information.
NOTE: When you create a copy of the Sports2000 database, you specify a database name and a location where you want to create the copy. When prompted for the location, use the working directory you defined when you installed the product. By default, this directory isC:\Progress\wrk\
.Making a copy of the Sports2000 database allows you to make changes to the copy but preserves the original database that you installed with your program files. In addition, you can delete your current copy and make a new copy, or you can create additional copies of the Sports2000 database in the same directory using the Replace If Exists option.
Follow these steps to create and connect to your copy of the Sports2000 database:
- From the Windows Start menu, choose Programs
Progress
Desktop.
- From the ADE Desktop, choose the Data Dictionary tool icon.
- When you run the Data Dictionary, it looks for a connected database. If there is no connected database, the Dictionary Startup dialog box opens:
![]()
- The default selection for the Dictionary Startup dialog box is Connect to an Existing Database. For this exercise, select Create a New Database and choose OK. The Create Database dialog box opens:
![]()
- Type the path and new name for the new physical database. For example: c:\progress\wrk\sports2000.db.
NOTE: You should place your copy of the new database in your working directory. By default, this is- The default selection for the Create Database dialog box is An EMPTY Database. For this exercise, select the radio button to create a copy of some other database.
c:\progress\wrk
.NOTE: The Sports2000 database is located in your Progress installation directory. By default, this is- Choose the Files button, browse to the location of the original Sports2000 database, and select it.
c:\program files\progress
.- Choose OK.
The Data Dictionary creates a copy of the Sports2000 database in your working directory. The Connect Database dialog box opens and displays the name of the database you just created:
![]()
- Choose OK in the Connect Database dialog box. The Data Dictionary makes the connection and its startup window opens:
![]()
You have now created and connected to your working copy of the Sports2000 database. The Data Dictionary window lists the Sports2000 database as connected and the tables in the database.
The icons in the toolbar govern what you can do with the Data Dictionary and what information displays for the selected database. When you choose an icon, buttons for varying tasks appear at the bottom of the window. Table 2–1 lists the icons and their associated displays and tasks.
- Use the Data Dictionary to familiarize yourself with the structure of the Sports2000 database.
- When you are ready, choose Database
Exit to return to the ADE Desktop.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |