There are actually two bugs to list here …
- Under Model > Generate DDL Script, the location of SQL File value is saved with the model. This provides errors when opening the model and attempting to generate the SQL on other machines.
EX: C:\Documents and Settings\shannara\My Documents\Toad Data Modeler\GeneratedScripts\Generated.SQL <-- is the default location on my machine, and since I generated the DDL last, it is saved in the model.
However, when my supervisor tries to generate the DDL, we get errors since the “shannara” user does not exist on his computer …
- When he tries to use a valid path such as %My Documents%\shannara\My Documents\Toad Data Modeler\GeneratedScripts\Generated.SQL <— The modeler gives off an incorrect error message (stating path not found or some such), yet, still generates the SQL file correctly, and in the correct path.
My question is why not use the environment variable by default %My Documents% instead of a hard coded path that does not exist on machines that did not create the model?