Chat now with support
Chat with Support

Toad Data Modeler 6.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Legal Information

Editable Forms and Frames

Features and Tools > Scripting and Customization > Customize Forms and Frames > Editable Forms and Frames

Toad Data Modeler allows you to edit some forms and frames for more comfortable work.

What Is Editable Form?

It is a form of which appearance you can edit to meet your needs and requirements. You can add, change components and delete user components (those you created).

How Do I know the Form is Editable?

Right-click the form to see the pop-up menu. If there's the Customize Form (as) option, the form is editable.

Example: The Entity Properties form

What Is Editable Frame?

Properties of editable frames are similar to properties of editable forms, however frame represents only a part of a form, not  complete form. E.g. the Options form has editable frames Application, Graphics etc.

What Is Editable Form for?

To customize appearance and functionality of forms to suit your needs, e.g. you want to have different options for different database types.

If you model your own property in metamodel, you will probably want to visualize it somehow (write out its value to edit etc.) Therefore it's necessary to edit appropriate form and insert to it a new component to which you will assign appropriate property then. Also, to inserted components, you can add values by scripting.

To edit a form

Right-click the form and select Customize Form or CustomizeForm as.

Customize Form

The changes will be saved to your user package My Package.

Customize Form as

The changes will be saved to another package than My Package. This option is disabled by default. To enable it, select Settings | Options | Expert Mode and uncheck the Save the definitions to the My Package checkbox.

Forms can be edited via the following tools :

  • Component Inspector - list of properties of selected component in the form. Here, you can edit properties
  • Component Palette  - list of components that you can add to a form
  • Form Explorer - tree structure of the edited form
  • Alignment - alignment options

Forms of these three tools can be docked in Toad Data Modeler environment  at your convenience.

If you want to hide/show any of these tools permanently, you can clear/select appropriate option in:

  • Right-click the form and select Designer Mode Options.
  • From the Settings menu, select Options | Editable Forms.

Example: The Entity Properties form that is being edited now.

 

To finish editing a form

Close the form that you have just edited (click x in the right-hand corner, e.g. in the Entity Properties form).

After you close the edited form, you need to save the changes to package.

Note: You will not finish editing the form by closing any of the tool forms (Inspector, Explorer or Palette Component). If you close any of them, the Show option for the tool (Show Inspector, Show Explorer...) will be automatically cleared. If you edit a form next time, the form of this tool will not display. To display it again, you need to enable the Show option either in the Designer Mode Options or in the Settings menu | Options | Editable Forms.

 

To save the changes

  1. Right-click the form and select Save Form or Save Form to.

The changes will be saved to appropriate packages, however to preserve them even after you close the application, you have to save also the packages.

  1. Save the packages in Package Explorer.

Changes will be saved either to actual package, or user package (according to the settings in the Settings menu | Options | Paths).

If you want to save the changes to another package, you have to start the edit process with option Edit Form as, then select the package and finally click Save Form to to save the changes.

Editable Forms Right-Click Options

Right-click the form to see the following options:

Option Description

Customize Form

Edits a form. All changes will be stored to My Package user package (file My Package.txg).

Customize Form as

Edits a form in a state according to the selected package. (Only the components that are saved in the selected package and its child packages will be available.)

This option is available only if checkbox Save the Definitions to the 'My Package' is clear. - See the checkbox in the Settings menu | Options | Expert Mode.

Load Form

Reloads a form.

Save Form

Saves changes in the default package (see the Settings menu).

Save Form to

Saves changes to previously selected package (see Edit Form as).

Designer Mode Options

Here, you can hide/show the tools for next form edit.

Default Values of Object

Opens the dialog where you can define or edit default values of appropriate form/dialog/frame.

Component Inspector

Features and Tools > Scripting and Customization > Customize Forms and Frames > Component Inspector

Component Inspector is a list of properties of the selected component in the form. Here, you can edit properties.

Option Description

Top combo-box

Select a component to display in this dialog.

Left Column

Displays property names.

Right Column

Displays values. Most of the values can be changed in inplace editors.

Note: If you select components directly in the form you edit, you can select more components using the SHIFT key. Then, only common properties will be displayed in Component Inspector.

Right-click the Component Inspector form and select Properties.

Here you can edit colors of specific parts of the dialog, and select other options.

Component Palette

Features and Tools > Scripting and Customization > Customize Forms and Frames > Component Palette

Component Palette is a list of components that you can add to a form. It is divided into two parts:

  • Data - here you can find components that can follow up with already existing properties
  • Standard -  other components that can be used for change of appearance or better classification of components

To insert a component to a form

  1. Select a component from the Component Palette.
  2. Click to a place where you want to insert it.  

To display components with small buttons

Right-click the Component Palette form and select Properties | Small Buttons.

Form Explorer

Features and Tools > Scripting and Customization > Customize Forms and Frames > Form Explorer

Form Explorer displays tree structure of components in a form.

In Form Explorer, you can move components, select them for edit in Component Inspector (via mouse), and delete them (Delete key).

Right-click the Explorer form and select Properties.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating