Dictionary Editor

Top  Previous  Next

Overview and Introduction

The lessons that follow describe the creation and maintenance of database dictionaries. Database dictionaries define the physical layout of the data files to be accessed by an application, the relationships existing between files, and the rules for maintaining these relationships.

Programs that are created with the Application Generator in order to access data files require database dictionaries.


Lesson 1 - Data Import

In this lesson, see how easy it is to create a dictionary, and examine the different options that you have when importing data definitions.


Lesson 2 - Table Properties

Examine the options available for the tables that you import or create in your data dictionary.


Lesson 3 - Column Properties

Examine the many options available for each column defined in your dictionary. See how certain settings can help speed up and polish your applications.


Lesson 4 - Key and Index Properties

Explore the Key and Index options available in you data dictionary. Learn the importance of proper key definitions, and how it can save you time as you develop your applications.


Lesson 5 - Adding Relationships

Discover the importance of defining proper relationships between the tables defined in your dictionary.


Lesson 6 - Trigger Properties

Explore the use of Client-Side Triggers, and how you can easily enforce powerful business rules during normal database operations in your applications.


Lesson 7 - SQL, ODBC, and ADO Imports

Discover the deep support of Clarion’s data dictionary with SQL, ODBC, and ADO type databases. Examine the Dictionary Synchronizer, a powerful accessory that is built into the environment.


Lesson 8 - Advanced Features of the Dictionary Editor

The Dictionary Editor is packed with features and options that can accelerate your planning and development. This lesson explores several key areas.


Next: Lesson 1 - Data Import