a_valued_customer
Follow / 20 Sep 2017 at 1:13pm / Toad Data Modeler
Latest post by on 20 Sep 2017 at 3:50pm

Deleting a relationship without deleting the associated attributes...

Expand content
I created some wrong relationships within my model (TDM 6.1, Postgres 9.5) incorrectly linking the PK columns of both entities. At some point I added the correct relationships including adding the correct...

I created some wrong relationships within my model (TDM 6.1, Postgres 9.5) incorrectly linking the PK columns of both entities.

At some point I added the correct relationships including adding the correct FK columns.

I don't really know how I did it, but somehow the wrong relationship is now between both PK columns, and when I delete that relationship the two PK columns are deleted automatically as well (which of course I don't want).

So my question is: is there a trick so that I can delete that relationship but keep those columns that are incorrectly assumed to depend on that relationship?

It's "Relationship29" in the below screenshot. If I delete that relatioinship, TDM als deletes both ID columns.

If needed I can supply the model itself but I did not find a way to attach a file other then a screenshot here.

Unanswered 51 2 / Create an account to join the discussion.
smattiko83
Follow / 30 Aug 2017 at 4:12pm / Toad Data Modeler
Latest post by on 6 Sep 2017 at 12:28am

relationships, foreign key

Expand content
I am trying to connect the tables. one table has business_id, business_name and state_id, the other table has state_id and state name. When I try and connect the two by state_id it creates a new attribute...

I am trying to connect the tables. one table has business_id, business_name and state_id, the other table has state_id and state name. When I try and connect the two by state_id it creates a new attribute called business_id in the second table. I want state_id to be a foreign key in both. What do I need to do? Thanks.

141 2 / Create an account to join the discussion.
greg long
Follow / 24 Aug 2017 at 5:05am / Toad Data Modeler
Latest post by on 24 Aug 2017 at 8:42am

How to change default (Universal) attribute data type

Expand content
Boohoo - I just know this post is gonna get smashed, but... Where do I change the default attribute data type (for the Universal model) - it's set to Char(1) which seems entirely pointless? I've...

Boohoo - I just know this post is gonna get smashed, but...

Where do I change the default attribute data type (for the Universal model) - it's set to Char(1) which seems entirely pointless?

I've looked in Template Editor, looked in Defaults, looked in Dictionary, looked in Package Explorer.

I've probably ended-up in the right place once, but it wasn't obvious where to make the change

Thanks all.

Greg

100 2 / Create an account to join the discussion.
me_the_first
Follow / 11 Jul 2017 at 2:56pm / Toad Data Modeler
Latest post by Anonymous on 26 Jul 2017 at 11:59am

Firebird support

Expand content
Hello everyone In my company we are currently using Case Studio 2.23 (TDM before renaming) and we decided for an upgrade but we need firebird support which current version of TDM doesn't have (or...

Hello everyone

In my company we are currently using Case Studio 2.23 (TDM before renaming) and we decided for an upgrade but we need firebird support which current version of TDM doesn't have (or keeps it as a secret feature).

So my question is: Dont you know how to get firebird support into current version of TDM or which last version supported it?

Unanswered 298 2 / Create an account to join the discussion.
greg long
Follow / 21 Jul 2017 at 8:37am / Toad Data Modeler
Latest post by on 21 Jul 2017 at 12:38pm

Rename file under version control does not rename on disk

Expand content
I have a text document held inside a folder in a TDM 6.1 x86 Project folder under Subversion/TortoiseSVN bin control. I have R/W permissions on the Subversion Repository and on the Project working folder...

I have a text document held inside a folder in a TDM 6.1 x86 Project folder under Subversion/TortoiseSVN bin control.

I have R/W permissions on the Subversion Repository and on the Project working folder

When I rename a document inside a TDM version-controlled folder, that filename does change in Toad, but it does NOT change the name of the file on disk. 

Consequently:

  1. the filename in TDM no longer matches the filename on disk
  2. I can no longer activate the file from within TDM (double-click has no behaviour)
  3. version control retains the earlier name of the file
  4. version control does not know this newly-named file

Is this a feature or a bug, and is renaming non-Toad files from within TDM a bad idea?

As stated in a Post some time ago, the Project concept in Toad has merit but it must offer reliable file name/move/edit/delete functionality, else the concept is too limited for me to commit to using it as a 'project' manager.

Thanks

Greg

Unanswered 197 2 / Create an account to join the discussion.
carbotex
Follow / 10 Nov 2007 at 4:36am / Toad Data Modeler
Latest post by on 12 Jul 2017 at 7:18am

Where can i get TDM2?

Expand content
I have models generated by TDM2. Now I can't even load them with TDM3. I can't find TDM2 anywhere. Can you send me a link to download TDM2 or tell how what am I supposed to do with *.dm2 files...

I have models generated by TDM2. Now I can't even load them with TDM3. I can't find TDM2 anywhere. Can you send me a link to download TDM2 or tell how what am I supposed to do with *.dm2 files.

11933 9 / Create an account to join the discussion.
Sergio Lopez
Follow / 11 Jul 2017 at 4:02pm / Toad Data Modeler
Latest post by on 12 Jul 2017 at 6:57am

How to show schemas preceding the table names in the Workspace Properties...

Expand content
Hi, I am using Toad Data Modeler 6.2 and I have created a new workspace >> right click Edit >> and then the 'Workspace Properties' window is presented. I can see a list with all my...

Hi,

I am using Toad Data Modeler 6.2 and I have created a new workspace >> right click Edit >> and then the 'Workspace Properties' window is presented. I can see a list with all my tables but I need them being preceded by the schema name as some tables have the same name and then I don't have a way to figure out which ones I am looking for and I have to add them both and then remove the one with the wrong schema.

I guess I am looking for something similar to the option 'Full Names' in the dropdown in the menu closed to the Report button.

Kind regards,

Sergio.

Unanswered 284 1 / Create an account to join the discussion.
orangeCat
Follow / 24 May 2017 at 7:39pm / Toad Data Modeler
Latest post by on 7 Jul 2017 at 12:34pm

Freeware Toad Data Modeler

Expand content
I have been using Toad Data modeler freeware 32bit since Dec 2016. The 120 days limit is approaching and I'm trying to re-download as the site said - simply download. But am having difficulty, even...

I have been using Toad Data modeler freeware 32bit since Dec 2016. The 120 days limit is approaching and I'm trying to re-download as the site said -simply download. But am having difficulty, even though I have created an account with address, email, phone etc., updated my profile. When I complete the form to initiate the download, the submit button does not seem to work. It's possible it is rejecting my PostalCode, but it was accepted on the account creation. I see various references to Toad, Quest and Dell and am confused as to what or how these fit together.

I am on a few data base forums and participate with design and draft models. The freeware edition of TDM is very adequate for my use, and I would like to re download the latest version before my current freeware expires. I am a retired data management person.

Any info to clarify the terminology, and especially for how to get this freeware download sorted would be most welcome.

Thanks.

orangeCat

Unanswered 460 3 / Create an account to join the discussion.
Buzzard001
Follow / 26 Mar 2013 at 11:23pm / Toad Data Modeler
Latest post by Anonymous on 1 Jul 2017 at 3:18pm

Adding a default set of Audit Columns for each entity

Expand content
I'm trying to find a way to add a default set of columns to each enntity for auditing purpose for each entity. I want to automatically generate all the column when the an entity is created. ...

I'm trying to find a way to add a default set of columns to each enntity for auditing purpose for each entity.  I want to automatically generate all the column when the an entity is created.

The set of colums is required for each table in the model below:

Insert_Datm    date  not null,
Update_Datm  date  null,
Error_Flag        char(1)  not null,
Delete_Datm   date  null,
Source_Key     Varchar2 (256) not null

If there's no way to autogenerate these, is there a way cut/past all colums into the DM at one time?

Thanks

11462 3 / Create an account to join the discussion.
rada
Follow / 26 Jul 2016 at 12:30pm / Toad Data Modeler
Latest post by on 30 Jun 2017 at 11:00am

TDM 6, Create entity and Attribute comments

Expand content
Hi, After I enter Model action, and I click Entities and check to generate Comments...and I close it....program doesn't keep this setting. Generating script from model action doesn't generate...

Hi,

After I enter Model action, and I click Entities and check to generate Comments...and I close it....program doesn't keep this setting.

Generating script from model action doesn't generate entity and attribute comments at all.

Tested on x86 version.

Any suggestions how to solve this?

Lubo.

2009 5 / Create an account to join the discussion.
a_valued_customer
Follow / 3 May 2017 at 7:28am / Toad Data Modeler
Latest post by on 12 Jun 2017 at 12:26pm

Extremely slow loading of the forum

Expand content
... this might be because of the performance. Loading the landing page of the forum takes ages for me and usually doesn't finish unless I try multiple times. Sometimes it works if I login before...

... this might be because of the performance.

Loading the landing page of the forum takes ages for me and usually doesn't finish unless I try multiple times. Sometimes it works if I login before visiting the forum.

When tracing the network calls using wget I see this:

--2017-05-03 08:25:07--  www.toadworld.com/.../default.aspx
Resolving www.toadworld.com (www.toadworld.com)... 12.106.87.211
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: www.toadworld.com/.../f [following]
--2017-05-03 08:25:08--  www.toadworld.com/.../f
Reusing existing connection to www.toadworld.com:80.
HTTP request sent, awaiting response... 200 OK
Length: 69159 (68K) [text/html]
Saving to: 'www.toadworld.com/products/toad-data-modeler/f/default.aspx'

www.toadworld.com/products/toad-data-modeler/f/de 100%[===============================================================================================================>]  67.54K   105KB/s   in 0.6s

Last-modified header missing -- time-stamps turned off.
2017-05-03 08:25:09 (105 KB/s) - 'www.toadworld.com/products/toad-data-modeler/f/default.aspx' saved [69159/69159]

Loading robots.txt; please ignore errors.
--2017-05-03 08:25:09--  www.toadworld.com/robots.txt
Reusing existing connection to www.toadworld.com:80.
HTTP request sent, awaiting response... 200 OK
Length: 69 [text/plain]
Saving to: 'www.toadworld.com/robots.txt'

www.toadworld.com/robots.txt                      100%[===============================================================================================================>]      69  --.-KB/s   in 0s

2017-05-03 08:25:09 (869 KB/s) - 'www.toadworld.com/robots.txt' saved [69/69]

--2017-05-03 08:25:09--  www.toadworld.com/.../layout.css
Reusing existing connection to www.toadworld.com:80.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:25:29--  (try: 2)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:25:59--  (try: 3)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:26:37--  (try: 4)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response...

--2017-05-03 08:27:08--  (try: 5)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:27:40--  (try: 6)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response...

So there seems to be something wrong when loading the CSS file for the site.

367 2 / Create an account to join the discussion.
Jake
Follow / 20 Mar 2014 at 7:29pm / Toad Data Modeler
Latest post by on 9 Jun 2017 at 7:48am

Straight Line Option Missing from Workspace Format

Expand content
I don't have the option to format the relationship lines to straight (like I did in the previous version). Is the option located somewhere else? v 5.2.4.25 Thanks. Jake.

I don't have the option to format the relationship lines to straight (like I did in the previous version).

Is the option located somewhere else? 

v 5.2.4.25

Thanks.  Jake.

15123 27 / Create an account to join the discussion.
costabas
Follow / 1 Jun 2017 at 7:45pm / Toad Data Modeler
Latest post by on 2 Jun 2017 at 9:22am

Placing connectors between tables optimally

Expand content
Hi: I am using straight lines connectors between tables with 90 degrees elbow points. I find that I am spending more time than I wanted to moving around connectors to have a nice and clean look, especially...

Hi:

I am using straight lines connectors between tables with 90 degrees elbow points. I find that I am spending more time than I wanted to moving around connectors to have a nice and clean look, especially when there are lots of tables involved.

I noticed that when I move the tables around, the connectors are not placed using the shortest distance - if possible - they tend to retain their elbow points but that leads to convoluted links. I have to admit, it's hard to explain without showing it.  Check out the two images. Genre is below Film to start with,  and the connector is straight. Then I moved Genre to the left of Film and the connector is below them. An optimal connection would have placed the connector between Genre-right to Film-left or Genre-bottom to Film-left. Using the Optimal style to All lines has disadvantages, especially if you have more than one link between two tables - sometimes they are overlapped or very close. The other thing that I want to avoid is selecting Optimal style every time I move a table. I want the tool to do it for me.

Any thoughts?

Thanks

273 1 / Create an account to join the discussion.
marbleberg
Follow / 24 Jun 2013 at 5:41am / Toad Data Modeler
Latest post by on 26 May 2017 at 8:23am

Need to recover access database with superior solution to fix access...

Expand content
I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error...

I have a task regarding access database. I and my organization is using access database  to maintain my access files in well mannered way. But due to varied reasons access file showing error message

Error 3112: Your access database got corrupted will not be able to show the database.

Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

Unanswered 21519 27 / Create an account to join the discussion.
costabas
Follow / 25 May 2017 at 8:24pm / Toad Data Modeler
Latest post by on 26 May 2017 at 7:50am

re: the Generation dialog

Expand content
I thought of sharing my experience using the sql Generation Dialog. - It doesn't have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often. - re: Actions...

I thought of sharing my experience using the sql Generation Dialog.

- It doesn't have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often.

- re: Actions: I am not to sure how Actions are supposed to work. Every time I change a setting in that dialog I am scared that I am going to loose that setting so I end up saving the action - The problem is that it creates a new action every time even when I use the same name instead of overwriting the one with the same name and I end-up having to items with the same name in the Load Action drop-down. 

How about renaming Action to Generation Settings and changing the behaviour to overwrite the settings with the same name. Otherwise I have to use numbers, Action01, Action02 ... to know which one is the last one which becomes annoying when you make changes and re-generate the script often.

-Not all the foreign keys of the tables I selected are included. In the Referential Integrity tab I checked Always, so I thought all the foreign keys are selected from the tables I selected for generation but that's not true. I had to go Select List -> Relationships and check them there.

That's it for now with this dialog.

Overall, my experience with the tool has been so and so. This morning when I came, some changes I made yesterday were gone. I left the program running. Not sure what happened. Maybe there is no point in mentioning it, but what the heck. Now I got into a paranoid mode and I click Apply every time I have a chance and save very often.

291 1 / Create an account to join the discussion.
costabas
Follow / 24 May 2017 at 12:56am / Toad Data Modeler
Latest post by on 24 May 2017 at 5:49pm

Captions for links between tables

Expand content
Is there a way to specify distinct captions for the two ends of a relationship between two tables in a physical model? As an example, from the video rental model, a Customer borrows movies, I wanted...

Is there a way to specify distinct captions for the two ends of a relationship between two tables in a physical model?

As an example, from the video rental model, a Customer borrows movies, I wanted to add one caption on the Customer side, Borrows, and on the other side, Borrowed by.

I used before ER/Studio from Embarcadero and you could add descriptions on both ends of a relationship. I was curious if you can do something similar in TDM. I find that sometimes having captions on both sides of a relationship can enhance the readability of the model.

Thank you

Update: I started to use Rectangle Labels. Is there another way?

Unanswered 343 2 / Create an account to join the discussion.
gnkurup
Follow / 19 May 2017 at 3:12pm / Toad Data Modeler
Latest post by on 22 May 2017 at 7:55am

Toad Data Modeler: Update Model from Database

Expand content
I am new to the Toad Data Modeler. I have created a couple for ERDs through this tool. I would say this is a wonderful tool. But after creating the ERDs, there are a couple of changes in the database....

I am new to the Toad Data Modeler. I have created a couple for ERDs through this tool. I would say this is a wonderful tool. But after creating the ERDs, there are a couple of changes in the database. I have designed the model in a printable format with great difficulty (as I am not a good designer). But once the change is made, I am not able to revise my ERD. I have tried it through Update Model from Database (I got this idea from a different thread)

https://www.toadworld.com/products/toad-data-modeler/f/30/t/2767

Unfortunately, that is not working for me. When I am trying with this. It is asking me to select the tables again from the scratch. Please let me know whether I am doing anything wrong or this is the way the tool behaves. Is there a better way to do that. If I am not clear, please go through the above link. I have the same question that he had.

Unanswered 420 3 / Create an account to join the discussion.
greg long
Follow / 10 May 2017 at 1:37am / Toad Data Modeler
Latest post by on 16 May 2017 at 9:43am

Can I use bracket for all field names in SQL code generation

Expand content
I have a client who insists on using some reserved words in their database that I'm rebuilding. Instead of having the argument about best practice and losing their confidence I'd like to be able...

I have a client who insists on using some reserved words in their database that I'm rebuilding. 

Instead of having the argument about best practice and losing their confidence I'd like to be able to add square brackets automatically around ALL entities/attributes when generating the SQL / ADO.

Is this possible?  

(I note Toad will delimit entities/attribute values that have spaces so I assume it's possible somehow).

Many thanks

Greg

677 11 / Create an account to join the discussion.
SPDToad
Follow / 26 Apr 2017 at 7:37am / Toad Data Modeler
Latest post by on 14 May 2017 at 7:50pm

Spell Checker

Expand content
Hi, I use the comments and descriptions options in my model to document my database. In SQL Server this information is subsequently added to custom properties in the database which I then extract into...

Hi,

I use the comments and descriptions options in my model to document my database. In SQL Server this information is subsequently added to custom properties in the database which I then extract into administrator reports.

Typos in those comments and descriptions are very bad so I am wondering if anyone has any suggestion for how to spell check these properties without having to cut-n-paste the text into another window.

Thanks

Steve

290 1 / Create an account to join the discussion.
pstein
Follow / 27 Mar 2017 at 2:11pm / Toad Data Modeler
Latest post by on 5 May 2017 at 10:42am

How to move folder AppData-Roaming-Dell-Toad-Data Modeler to other...

Expand content
I prefer to keep all components of a program together. Unfortunately Toad Data Modeler creates a settings folder C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\ while the main installation...

I prefer to keep all components of a program together.

Unfortunately Toad Data Modeler creates a settings folder

C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\

while the main installation folder is in

D:\tools\ToadDataModeler\

How can I move the settings folder to another directory?
I prefer a subdirectory like

D:\tools\ToadDataModeler\mysettings\

Therefore Toad Data Modeler should automatically look at first in this customized location before the software looks at
C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\

Another solution could be to pass a parameter at the commandline similar to

D:\tools\ToadDataModeler\\Bin\TDM.exe -settingsfolder="D:\tools\ToadDataModeler\mysettings\"

Is this somehow possible?

Peter

603 4 / Create an account to join the discussion.