Greetings again Vladka & Team.
First off, I’m LOVING the new beta. The new layout is immensely easier to use and the SQL Preview tab now showing up in the Stored Procedure editor is VERY HELPFUL. It allows me to make sure I have all the pieces together properly for the code that is generated without having to dig deep into the generated SQL file. Thanks for that! I did have a couple things I wanted to share after working on the new beta yesterday.
When I add a new stored procedure, give it a name, and click Apply, the physical model explorer does not refresh it’s sort order (set to by name) automatically. The re-sort occurs after I select the “Sort By Name” option again. I don’t know if this is a bug or just the standard way the Physical Model Explorer is designed to function.
I like the new “collapse/expand” items that show up in the SQL Preview. However, I’m not quite sure how SQL Preview is grouping is setup to expand collapse tabs. Is this working properly? I attached a screenshot where the + and - seem to be in odd places.
What does the Icon on the SQL Preview tab of the Stored Procedure editor do? I didn’t see a tooltip or a message when I clicked on it.
Since the docked Physical Model Explorer is the new “default” view, can allow a double click on the section name (Procedures, Entities, etc.) and have it bring up the dialog window, similar to a Right-Click -> Edit?
Have you ever thought about support SQLite as a generator model. It is actually quite simple since it is ANSI92 compliant and doesn’t do stored procedures or much. Since there aren’t any robust tools out there I’ve found for managing SQLite databases, having TOAD generate an initial schema would really help in complex situations.
- After making a few stored procedure modifications, I clicked the save button and then the Generate Script button. I got a TDM exception, shown in screenshot. After clicking OK. I clicked the generate button again and things worked just fine. Not sure if it is isolated or not, but I wanted to mention it.
All in all things are getting better and better. Keep up the awesome work guys, you have a great product here!