Hello all,

I’m happy to inform you that a new Beta version 3.2.2.22 has been released.

Feel free to read about all changes in Beta 3.2.2.22 at:
http://modeling.inside.quest.com/entry.jspa?externalID=1913&categoryID=29

Beta download:
http://modeling.inside.quest.com/ann.jspa?annID=150

With the new TDM Beta release, I’d like to introduce you some of the new features/enhancements.
As the Help file and Manual are not being updated for Beta releases, I’d like to take advantage of our weblog to provide you with some helpful and important information, give tips and post references on the new improvements. So, let’s go…
Select a topic that interests you:

1. Support for MS Access 2000/2002/2003
2. Import from SQL Script - for Oracle models only
3. SQL Code Generation by SCHEMA/USER + Auto Check
4. Adding Attributes to Primary Key via Double-Click
5. Alignment of Relationship Break Points
6. Move Caption of Relationship
7. Navigation in Workspace
8. Autolayout
9. Wordwrap
10. New Workspace Properties Dialog
11. Model Properties versus Stamp

1. Support for MS Access 2000/2002/2003
Toad Data Modeler doesn’t generate an SQL script for the MS Access database, but does generate a fully functional source code in the VBA language. The source code can be executed directly in the MS Access as Module. Appropriate libraries in MS Access are necessary - “Microsoft ActiveX Data Objects 2.x Library” and “Microsoft ADO Ext. 2.x for DDL and Security” for ADO, or “Microsoft DAO 3.6 Object Library” for DAO.
To select a suitable library, click the Tools menu | References (in MS Access main menu).

In the beginning of every script generated for MS Access, you will see the following order:

(more…)

Hello TDM users and fans,

Let me invite you to take part in the survey regarding Toad Data Modeler. If you could take the time to fill out the questionnaire, our teams would appreciate it very much.

Please let us know your experience with Toad Data Modeler, what database platforms and features you miss,  what TDM feature you like to enhance as you use it most often, what your purchase experience is etc.

Please visit this site:
http://modeling.inside.quest.com

and click the Customer Survey button.

Your feedback matters to Quest!

Regards,

Vladka

Hello,

This is the last part of the series about managing relationships in Toad Data Modeler.

MULTIPLE SELECTION

Situation A:
I make multiple selection of entities via SHIFT key. I want the relationship lines to be selected automatically too.

In the Objects menu, enable the Select Links Automatically option.

Situation B:
I select an entity, its self-relationship line is selected too, which I do not want.

Press SHIFT and click the self-relationship.

Situation C:
I need to make multiple selection of relationship lines.

Press SHIFT, hold it down and click the relationships.

MOVE

Situation A:
When I move an entity, I need to preserve position of the break points on the relationship line too.

1. Select the entity and also the relationship (SHIFT key).
2. Drag and drop the entity to the required position.

Situation B:
An entity covers the relationship name/break point. How can I get to them?

Click the relationship, the caption/break point will be highlighted. Feel free to move it to another position.

Situation C:
When I move an entity, I would like to see possible positions of its relationships.

In the Objects menu, enable the Recalculate on Move option.
==============
Well, I hope you found some good tips here. Next time, I’ll provide you with some tips on how to search an entity in a workspace.

I look forward to your comments.

Regards,

Vladka

Hello,

Here I’m with another part of our series about relationship lines. Today’s topics are:

BREAK POINTS and HIDE/FORMAT RELATIONSHIP NAMES.

Situation A:
Can I add break points in both modes - Straight and Right Angled too?

Yes, simply select the relationship, press CTRL, hold it down and click the relationship line where you like to add the break point.

Situation B:
I cannot remove a break point from a relationship in Right Angled mode. Is it possible at all?

In this mode, you can remove only break points that do NOT break the line. E.g. if you have several break points in one line segment, you can remove them. However, you are not allowed to remove break points that break the line and keep/make it right-angled.
To remove a break point:
1. Select a relationship.
2. Press CTRL, hold it down and point your mouse cursor at a break point you’d like to remove. -> The mouse cursor will change to a small black arrow.
3. Click the selected break point.

To remove unnecessary break points from a relationship at one jump:
Right-click the relationship and select Reduce Breakpoints.

Situation C:
I cannot move a break point in Right Angled mode. Is it possible at all?

No, it is not possible. In Right Angled mode, you can only move line segments. To select any, press ALT and click the selected line segment. Then use drag and drop techniques or keyboard arrows to move it.

Notes:
- In upcoming Beta 3.2.2.22, it will be possible to select several line segments via the SHIFT key (in Straight mode).
- In upcoming Beta 3.2.2.22, it will be also possible to align selected break points (there will be the new option Align Breakpoints in the Edit menu).

HIDE/FORMAT RELATIONSHIP NAMES

Situation A:
I need to hide relationship names in Workspace.

Right-click the WS | select Workspace Format | General tab | clear the Display Line Names checkbox.
To set it up for new models/workspaces, select Settings | Options | Physical/Logical Model | clear the Display Line Names checkbox.

Situation B:
I need to change format of names for selected relationships at one jump.

1. Make selection of the relationships (SHIFT key).
2. Right-click any relationship | select Format | General tab | Font Settings.

Note: In upcoming Beta 3.2.2.22, it will be also possible to move caption of relationship line, which may come in handy if your model is large and you need to know the name of the relationship on particular place of the ERD, or if the caption seems to be lost in your large ERD.
==============
Next time, some tips on selecting and moving relationships will be given.

Have a nice day.

Regards,

Vladka

Hello,

Our series about relationship lines in Toad Data Modeler continues. Today I’d like to write about creating relationship lines and adding shortcuts of relationships to new or already existing workspaces.  
See below some situations (taken from often asked questions) and possible solutions. More screenshots will be presented today.

Enjoy!

CREATE A RELATIONSHIP

Situation A:
I need to create several non-identifying relationships.

1. Press SHIFT and click the Non-identifying Relationship icon. A blue frame will appear in the icon.
2. Create as many relationships in you model as you need. To turn this function off, right-click the work area (or click the Relationship icon again).

Situation B:
I need to define a track for the relationship line on my own while I create the relationship. (Not satisfied how TDM adds relationships automatically.)
(more…)