Go to Glossary Search VisualAge C++ Help Go to VisualAge C++ Help Home Page Go to WWW VisualAge C++ Site

Data Access Builder Window

The Data Access Builder window allows you to view and customize the schema mapping. The schema mapping is created by the Data Access Builder SmartGuide to store information to generate code. The window has a menu bar:

  1. File
  2. Selected - Shows the valid actions for the selected icon. These items are also available in the icon's popup menu.
  3. View
  4. Options
  5. Help

Schema Mapping
Data Access Builder creates schema mappings, which contain information for source code generation. The schema mapping is displayed as a tree view. The schema is a database object which can be a database table, view, or a logical grouping of columns specified in an SQL query. The schema is represented as one of the following icons:

Schema is a table Schema is a view Schema is an SQL query

To view schema information (for example, column names and SQL types), double-click on the schema icon to open its properties notebook. The following operations for the schema object are available from the Selected menu, or from the schema's popup menu:

Each schema may have zero or more mappings. Each mapping contains sufficient information for Data Access Builder to generate C++ classes. For example, it has definitions for all attributes matching all the columns for your database table, view, or SQL statement. This mapping is then used to generate C++ classes that could include add, update, delete, and retrieve methods. You can also customize the mapping by changing attribute names or by adding your own methods before code generation. Under the schema icon, each mapping is visually represented by this icon:

Mapping icon

When the source code for the mapping has been generated, the table piece changes color. When there is an error in a user-defined method in that mapping, its icon has a red cross above it . When you generate classes, the code will not include methods that have errors.

Double-click on the icon to open its properties notebook and view information such as generated file names. The following operations for the mapping object are available from the Selected menu, or from the mapping's popup menu:

Attributes
Each mapping defines attributes for all the columns of the specified database table, view, or SQL query. When you expand the mapping. The attributes that are mapped are displayed in the tree structure as the following icons:

attribute attribute that is a data identifier

The following operations for the attribute objects are available from the Selected menu, or from the attributes' popup menus:

 



Data Access Builder
Data Access Builder Workflow


Create Mappings
Start Data Access Builder SmartGuide
Import a Data Access Builder Session
Export a Data Access Builder Session
Change Mapping Properties
Change Attribute Properties
Fix Broken Mappings


Data Access Builder SmartGuide