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 is C:\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:

  1. From the Windows Start menu, choose Programs Progress Desktop.
  2. From the ADE Desktop, choose the Data Dictionary tool icon.
  3. When you run the Data Dictionary, it looks for a connected database. If there is no connected database, the Dictionary Startup dialog box opens:
  4. 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:
  5. Type the path and new name for the new physical database. For example: c:\progress\wrk\sports2000.db.
  6. 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.
  7. NOTE: You should place your copy of the new database in your working directory. By default, this is c:\progress\wrk.

  8. Choose the Files button, browse to the location of the original Sports2000 database, and select it.
  9. NOTE: The Sports2000 database is located in your Progress installation directory. By default, this is c:\program files\progress.

  10. Choose OK.
  11. 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:

  12. Choose OK in the Connect Database dialog box. The Data Dictionary makes the connection and its startup window opens:
  13. 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.

    Table 2–1: Data Dictionary Icons 
    Icon
    Displays
    Available Task Buttons

    Connected databases
    Create Database
    Database Properties

    Tables in selected database
    Create Table
    Table Properties
    Delete Table

    Sequences in selected database
    Create Sequence
    Sequence Properties
    Delete Sequence

    Fields in selected table
    Create Field
    Field Properties
    Delete Field

    Indexes on selected table
    Create Index
    Index Properties
    Delete Index

  14. Use the Data Dictionary to familiarize yourself with the structure of the Sports2000 database.
  15. 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