Toad Data Modeler 6.5 - User Guide

Edit Associations

Double-click the association line on the Workspace.
or
Edit the association in the Associations dialog (Model menu | Model Items |Associations).

About Templates

Toad Data Modeler allows you to:

• Use pre-defined templates for properties that contain SQL code in your model (SQL, Before Script, After Script etc.).
• Create your own user templates for these properties.
• Set a default template for each property.
• Import Toad for Oracle templates.

Example: You have created an entity trigger. Edit it and see the SQL tab in the Trigger Properties dialog. The SQL code has been pre-defined = particular default template has been used (according to the database). You don’t have to write the code manually for every new created trigger.

To select another than default template in object Properties dialog

Press CTRL+A to highlight all text in the text box and select another template from the Templates box.

Note: To replace one template with another, all text should be selected. Otherwise, the new template selected from the Templates box will be inserted to the position of cursor in the box. This behavior allows you to put together partial templates.

Option	Description
Templates	Shows all active templates for this object.
	Inserts the selected template.
	Opens the Template Editor.

All templates are available in Template Editor.

Template Editor

To open Template Editor

Select Settings | Templates.

To display templates for particular database or database version

1. From the Model Type box, select the database or particular database version.
2. Click Load Templates.

Note: This option is available only if packages with the templates for selected database haven’t been loaded so far.

Option	Description
Commit	Confirms changes made in the Template Editor and saves them to particular packages. Note: Packages are not saved to your hard disk.
Commit and Save	Confirms changes made in the Template Editor and saves them to particular packages (.txg files). The packages are saved to your hard disk.
Rollback	Cancels changes made in Template Editor.
Import Toad for Oracle Templates	Imports templates from Toad for Oracle to the Toad Data Modeler Template Editor. Note: This option is available only if you have Toad for Oracle installed on your computer.
Model Type	Select a database or particular database version for which you want to display the templates. TIP: Feel free to open Templates Editor for different database platforms or versions, dock the windows, compare the templates.
	Creates a new template.
	Deletes the selected template. Click Commit to confirm the deletion.
	Opens the Template Properties dialog.
Object Category	List of objects (entities, attributes, triggers, check constraints, views, procedures etc.) with list of available SQL properties (SQL, Before Script , After Script etc.).
Parent	Information on parent object
Template Name	Specify any name for your template to distinguish it from others.
Default	Select this checkbox to set the template as default. The template will be pre-defined in the object Properties dialog.
Active	Select this checkbox to display the template in the Templates box in the object Properties dialog.
Template	Provides a quick view on the body of the SQL code.
Template body for template	Write the SQL code to this window. Note: Remember to save the changes Commit or Commit and Save.

Available Pre-defined Templates

There are two pre-defined templates – Body and Complete. Both relate to the Generate SQL Only checkbox on tab General of object Properties dialog.

• Body – The Generate SQL Only checkbox is deselected.

Example of default code for trigger:

BEGIN

/*trigger_body*/

END

• Complete – The Generate SQL Only checkbox is selected. (It means that settings on tab General are ignored in final SQL code.)

Example of default code for trigger:

CREATE OR REPLACE TRIGGER <%<%FullName%>%>

AFTER /*BEFORE*/

INSERT /*UPDATE | DELETE*/

ON <%<%TableFullName%>%>

BEGIN

/*trigger_body*/

END

To set this property for your user templates, see the Template Properties dialog, General tab and select or clear the Generate SQL Only checkbox.

Where Templates Are Stored

All pre-defined templates are saved in the Templates.txg file that is copied among user packages during first start-up of Toad Data Modeler.

All user templates are by default saved to My Package.txg.

Both files are stored among user packages at (default location):

C:\Documents and Settings\user name\My Documents\Toad Data Modeler\Installation name\Packages\{GUI}

Why are pre-defined templates stored in another package? - Once our team brings new pre-defined templates, you will be able to replace the old pre-defined templates with the new ones (Templates.txg). Your user templates will stay preserved in your My Package.txg.

We do NOT recommend to modify the pre-defined templates. If you do so, please remember to save the template to My Package.txg (see the Template Properties dialog, General tab, Package area.)

Manage Templates

To create a user template

1. In Template Editor, select Object Category (e.g. Triggers).
2. Click and write the code in the Template body for template window.

3. Confirm the changes Commit or Commit and Save.

To change properties of a user template (e.g. location, visibility etc.)

1. Select a template.
2. Click to open the Template Properties dialog.
3. Check properties of the template.
   
   

Option	Description
General Tab
Name	Write a name of your template.
Property Selection	Select for which database, object type and property the template should be used.
Active Template	Select this checkbox to display the template in the Templates box in the object Properties dialog.
Default Template	Select this checkbox to set this template as default in particular object Properties dialog.
Generate SQL Only	Select this checkbox to set the property Generate SQL Only enabled in the object Properties dialog. Available Pre-defined Templates
Package	Select a package where you want to save the template. By default, user packages are saved to My Package.txg. Where Templates Are Stored
Lock Package	Sets the ReadOnly property of the .txg file on the disk.
Visibility Tab	Select databases and database versions for which the template should be valid and available.

4. Confirm OK. 
5. Confirm Commit and Save.

To set a template as Default

1. Select a template in Template Editor.
2. Select the Default checkbox for the template.
3. Confirm Commit and Save.

To disable a template

(not to display it in the combo-box in the object Properties dialog)

1. In Template Editor, find the template that you want to disable and uncheck the Active checkbox.
2. Confirm Commit and Save.

To delete a template

1. In Template Editor, select the template that you want to delete.
2. Click .
3. Confirm Commit and Save. Now it is not possible to edit the template.

Note: After you reopen the Template Editor, the deleted item will be removed. The template has been deleted from the .txg package.