Greetings again Vladka!
Thanks for the quick response on the questions I had. I’m keeping all that info at hand. On to the bugs…
I’m a bit confused. Please check out the display level of Workspace and display level of the entity. -> Right-click the entity | **Format ** | Entity tab | Display Level .
(WS display level can be seen in the toolbar.)
I’ve done this and I’m still not seeing anything. I’m attaching a screenshot of the settings and my model file.
I’m sorry, I’m not sure if I undestand well. Is the SQL tab of the Procedure Properties dialog small for you?
If you enlarge the Properties dialog at your convenience, the modified dialog size will remain preserved when you open it next time (even for newly created procedures).
That is true, you can expand it, but one other thing you might have the app do then is remember the window position. I run a large window to enter my code and when the window opens again, it has it in the “center” position, which has most of my details off screen and requires me to move the window again. It may sound kind of nit-picky, but it does become a hassle to move the window every time.
I’m afraid, I need more details on what you require. (Sorry for my English.) Here’s what I guess you ask for (example on Procedures):
In Model Explorer | Procedures folder, all procedures are listed. When you double-click the selected procedure, you want to open its SQL code in the Application Window on a separate tab. - Similar to Script Editor.
The newly opened tab should consists of two windows - in the left one, list of procedures is listed (as you like to open more procedures), in the right window, the SQL code of the selected procedure from the left will be displayed.
Am I right? In any case, thanks for more details.
You’ve got it all right except one thing. The newly opened tab wouldn’t have two windows, just one window to edit the SQL script. If you wanted to add parameters, permissions, etc., you would right click on the procedure in the Model explorer and select “Properties”. This would open the window that is currently visible when you double click on a stored procedure to modify its properties.
Well, let me note that at the moment, TDM3 allows you to view/edit multiple procedures at once. Via the Model Explorer, you can open the Properties dialog | SQL tab of several procedures and work with them concurrently (copy the code, edit it etc.) The dialogs are modeless. See the attached screenshot.
Feel free to test it out.
I like that, I’ll have to work with that a bit more. Thanks!
Oh, a couple more items, if I may add them to this thread.
- OK+Add… I LOVED this feature in TDM 2. It made it a lot easier to add multiple columns when creating a table. Please put this back. I think its far more efficient than using the Add button in the Attributes section of a table multiple times and then going back to edit the “generic” items created.
Speaking of which, I don’t quite understand how a new attribute needs to be “confirmed” before you can edit it. I just used the checkbox to not prompt me again and got rid of the nuisance.
- Bug with Stored Procedure Window… This is the steps I took:
Using Stored Procedure Window
- Click Add to add new stored procedure
- Double click new “generic” procedure to edit
- Change name, caption, insert SQL code for procedure, update permissions, add SQL code to Before Script section.
- Hit Apply. I then lose name, caption, SQL, everything but Before Script, Owner, Permissions, List of Arguments
It appears that the Apply button only working on current tab. I need to “apply” on SQL tab in order for code to stick. I’ve also experienced the same behavior on the Before tab as well.
Thanks again for the great product. Keep up the hard work!