Detail Pane

From RemObjects Software

This is a Data Abstract Tool topic
Feel free to add your notes to this topic below.

The center of the Schema Modeler window contains the Detail Pane. Depending on which items you select in the other panes and the menu, you will see a different view here.

These views are displayed:

• Data Table Details: by selecting a Data Table in the left hand pane of the Schema Modeler.

This view allows you to adjust the properties of a data table, including the fields that make up its rowset, the parameters needed to retrieve the dataset (if any) and the statements used to obtain the rowset from the physical database.

• Command Details: by selecting a Command in the left hand pane of the Schema Modeler.

This view allows you to adjust the properties of a command, including the parameters needed to execute the command (if any) and the statements used to run it on the database system.

• Connection Details: by selecting a Connection in the right hand pane of the Schema Modeler.

This view allows you to adjust the properties of a connection, such as the name, the actual connection string, and whether the connection is the default connection.

• Relationships View: by clicking on the Relationships button in the Schema Modeler toolbar.

Allows you to edit and maintain the master/detail relationships and primary/foreign key connections between your data tables.

• Data Dictionary Editor: by clicking on the Data Dictionary button in the toolbar.

• Update Rules View: by clicking on the Update Rules button in the toolbar.

This view only occupies the top half of the center pane and this allows you to view the fields of a datatable underneath.

Update rules control the processing of a delta packet on the server. If no rules are defined, items in the delta packet are processed sequentially. For master/detail relationships that you wish to update in a single server round trip, it is important to get the processing order correct.

For a master/detail update in a single shot, you need four rules in the following order:

DataTable	Commands
master	Insert + Update
detail	Insert + Update
detail	Delete
master	Delete

Inserts and Updates can be combined because the delta packet will not contain an Insert after an Update for a particular item.

Once update rules are in place, they are applied sequentially to the delta packet.

• Diagramming and Modeling Support: can be activated via the Diagrams menu item or by right-clicking on any of the Datasets and by selecting New Diagram.

Diagrams allow you to visually layout related tables in a Entity Relationship diagram and visualize and create master/detail connections between your tables. You can drag more data tables from the Data Tables Pane to add them to the diagram.

Dragging one or more tables from the Data Explorer to the diagram will automatically add it to the list of data tables defined in the Schema Modeler's left panel, and will also automatically import relationship data between those tables, if the database driver provides relationship meta data.

Creating Master/Detail Relationships

Adding links can be achieved by clicking on a dataset field in the diagram and by dragging it to the appropriate field in another dataset. A link can also be modified by double-clicking anywhere on the connection line representing the link. In both cases, the following dialog will display, allowing you to adjust the relationship.

• Welcome Page: on startup and is also accessible via the Help | Show Welcome Page menu item.

See Also

• Schema Modeler
  • Data Tables Pane
  • Connections Pane
  • Data Explorer
  • SQL Editor

Product: RemObjects Data Abstract
Current version: Data Abstract 'Vinci' (5.0)

Lists — Glossary — Features — How To — Drivers — Components — Tools — Samples — Articles — Architecture — Issues