Toad World® Forums

Enhancement about Generate SQL feature


#1

Hi

Is it possible on SQL Script generation Wizard to allow user not to generate Collation information, so the collation of the database could use the database default one?

E.g. When the user need to compare data from different database, if the collection is different, the database will complain about the collection is not match, so it cannot execute the query …etc

I would be grateful if Toad data modeller could generate a collation drop down lists for Entity and Attribute Properties windows on “Collation” and “Character set” field, because at the moment user could enter any text in these two box, which may affect the SQL script which will be generated by Generate SQL script feature (Just in case people may mis-type the collation/ character set…ect

Question about Setting Options

On Options --> Model --> Physical Model, it displayed a list of SQL Server that is supported by Toad Data Modeller, when I selected one of database server name, it only displays the name of the server on the top right hand side of the screen, does it suppose to display some other options for the user to set up some setting for the specific database server?

I am wondering if it is possible to allow “Custom colour” as one of the colour option for the“editable forms/Form Explorer’” colour? At the moment use can only choose the default colour.

Could you give me some information about what “Options --> Application --> Dialog Boxes tab” suppose to do? At the moment I do not think it allow us to do anything as it does not have any options for me to add dialog box/ change any content on it …etc. I guess it is something related to the script feature which could be similar problem it has with the drop down list on reverse engineering wizard. (Please forgive me if my assumption is wrong)

On the Relationship Properties Windows
The Drop down list at the top of this windows, I assume it is used for displaying a lists of Relationship for user to choose the relationship that user would like to edit. At the moment the drop down list does not displays anything (Is it a bug?).
In Entity Properties --> SQL Preview
Will Toad Data Modeller user this tab to displays the SQL Script (Create script for the selected entity?) At the moment it does not display anything, is it a feature that not yet implemented? *(bugs?)?

Different features on Entity Properties Windows general tab
I had played around both Physical Data Model for (MYSQL5, SQL Server 2005) They have different behaviour, In MYSQL5’s Entity Properties windows, it allow user to choose(check) “If not exist” and “Temporay Table” but in SQL Server 2005, it does not have these features. I am wondering if it is bugs or these features only available on MYSQL5 Physical data model? Another thing is it on MYSQL Entity properties windows, It does not have a “Full Text Index” tab.

i would be grateful if the Temporay table could displays differently like “View”, It has dotted line, which make it easier to identifier what type of table/object it is. I knew that we could set it to a category to identifier it, but i still is a good idea to separate it in by the look of it.

I am wondering if it is possible to have extra Explorer windows/ enhance the “Physical Model Explorer” to allow user to navigate through the Procedures that created. At the moment user could navigate the Procedure through Physical Model Explorer, I think it would be better to have some more feature on Physical Model Explorer to filter down the group of object that the user would like to view within the explorer. E.g. The user may only want to view the specific model E.g. Procedure, View, Entities …etc. At the moment Physical Model Explorer displayed too much information which make it a bit hard to navigate.

I would be grateful, if the SQL tab could be enhanced to detect if it has SQL syntax error, the Procedure features is good, which allow user to enter the stored procedure that want to create, but unfortunately, it is not smart enough to detect if the syntax is wrong.
E.g. “Selct * From abc”, it would just create this SQL script when user use the “Generate SQL Script” feature. Which will break the SQL execution when user try to use the generated SQL script to create the database…etc

Problem - Not able to open .txp file by double clicking on it.
I am not able to open the model file by double clicking the .txp file From the Model folder. When I double click on it, it loads up the Toad Data Modeller and on the message windows, it displays “Error When loading input parameters” I guess it maybe a bugs or something wrong with my computer, as my computer is a bit old.
Please let me know if you want me to explain more.

Many thanks

Chi

Message was edited by: Chi


#2

Hello Chi,

Here I’m with replies to your questions.

Is it possible on SQL Script generation Wizard to allow user not to generate Collation information, so the collation of the database could use the database default one?

Now it’s not possible. However, we will consider it. CR # 35 828.

I would be grateful if Toad data modeller could generate a collation drop down lists for Entity and Attribute Properties windows on “Collation” and “Character set” field…

Users will be allowed to change it on their own in the future.

On Options --> Model --> Physical Model, it displayed a list of SQL Server that is supported by Toad Data Modeller, when I selected one of database server name, it only displays the name of the server on the top right hand side of the screen, does it suppose to display some other options for the user to set up some setting for the specific database server?

Concerning the Physical Model options for specific db type, it’s empty for now. Here, users will be able to add their own options in the future.

I am wondering if it is possible to allow “Custom colour” as one of the colour option for the“editable forms/Form Explorer’” colour? At the moment use can only choose the default colour.

We will consider your request. CR # 35 817. Thanks!

Could you give me some information about what “Options --> Application --> Dialog Boxes tab” suppose to do?

This section is empty until you forbid a dialog selecting the ‘Do not show next time’ option in the dialog itself. - If you select this option, a new checkbox on the particular operation will appear here.
Later if you like to enable (activate) the dialog again, you will select a checkbox of appropriate operation in the Options.

Examples:

  • Save Model - If it’s selected, the model for which you select Close Model will have
    to be saved.

“If not exist” and “Temporay Table” - SQL Server doesn’t support them.
“Full Text Index” - in MySQL, checkbox Fulltext index should be used.

i would be grateful if the Temporay table could displays differently like “View”, …

Temporary tables are database dependent and therefore it would be difficult to do what you require. Different users might have different requirements on the look. Graphical options are not database dependent.
Nevertheless, users will be able to customize it via scripting in the future.

I am wondering if it is possible to have extra Explorer windows/ enhance the “Physical Model Explorer” to allow user to navigate through the Procedures that created…

Thank you for your suggestion. We will deal with it. CR# 35 823.

I would be grateful, if the SQL tab could be enhanced to detect if it has SQL syntax error,…

Thanks also for this suggestion. We will consider it for future TDM 3 releases. CR # 35 824.

Problem - Not able to open .txp file by double clicking on it. I am not able to open the model file by double clicking the .txp file From the Model folder…

This is a bug in the last version. Thank you very much for your notification. We will fix it. CR # 35 825.

Chi, thank you for your time and fantastic feedback.

Note: Several different topics are raised in this one thread. I’d like to ask you to make a new thread for each topic next time. It wouldn’t be so long and will be much easier for other community members to find a reply/responses to certain topic. Thanks very much.

Have a nice day.

Vladka

  • Deletion of Explorer Items - If it’s selected, the item for which you select Delete
    Item in Model Explorer, will be deleted from your model without further confirmation.

On the Relationship Properties Windows… the drop down list does not displays anything (Is it a bug?).

Thank you for your bug notification! We will fix it. CR # 35 819.

In Entity Properties --> SQL Preview…

Please click the SQL Preview button in the down left hand corner of the dialog | SQL Preview tab. Thanks.

Different features on Entity Properties Windows general tab…

If there’s some feature different it can mean that:

  • the database doesn’t support it,
  • the database supports it, however in a different way,
  • we haven’t implemented the feature (e.g. as it is not used or as it would confuse users).

Example: