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.
Message was edited by: Chi