Wishlist on various things

[ScottMattes]

I have spent the last month onsite using less than state of the art equipment - the only saving grace is that the customer finally agreed to buy PLSD so we can stop putting out copy on while he isn't looking!

Anyway, I have some observations.

- when loading the body of a package I would like to see a busy cursor - so I know that it is loading (as opposed to not having privs to see the body)

- if I right click a proc/func in the package navigator I would like a 'goto body definition' item that takes me to the body where that proc/func is defined

- all grids should scroll when I drag the scroll thumb (for sure the one record view of the SQL Window does not, but I think that there are others)

- maybe an option so that if no project is open and I have any windows opened and I decide to create a project I really don't want the open files closed (along with having to decide whether to save their changes). If no project is open and there are windows opened when I do a Project / New just never mind and leave those open windows alone.

- in the Test Window it would be nice to be able to stop the updating of the DBMS_OUTPUT tab.

- on the SQL Window I would like a tab or something to let me at the substitution variables without having to Execute

- it would be nice if the SQL Window let me specify bind variable values as well as substitution variable values

- could the Explain Plan Window be made to support substitution and bind variables?

- if I have the Window List floating it would be nice if it could be rolled up like the Describe windows.

- even on faster equipment I think that it would be nice if the Describe info (Tables/Views/Procs/etc) could be saved to local disk and reused (LoadFromFile is much quicker than a query). Maybe an option to refresh on some schedule (session/day/week) or to check when used to see if it has changed from when it was saved to disk? Maybe when the schema is selected in the left hand pane you could do one query to see the last dates on all objects in that schema?

Since we have gotten the customer to agree to buy PLSD we have been showing his folks neat stuff about it. I feel real good listening to some of them talking about how neat the tool is and how they can't wait to get it installed.

Thank you and please keep up the good work!

 

[Marco Kalter]

Thanks for your suggestions. I have added them to the list of enhancement requests.

 

[ScottMattes]

various other things that I have observed since my last post (boy, are the PCs we are working on slow).

- describe window: I would like some way to quickly shrink that window down width wise to only show the column name

- templates: it would be great to be able to specify that the template should execute immediately on being pasted into the SQL Window

- on the program window nav pane: would like additional sort orders; reverse by name and by type and name (with reverse of course)

- when viewing query results as a single record: need buttons to scroll to the bottom/top of the result set (not to be confused with the existing get all rows button)

- when viewing query results as a single record: I would like the display to scroll as I drag the vertical scroll thumb, like the multi rows grid does now

That does it for now. Thank you for this great tool!

 

[Joachim Rupik]

Hello,

A new version of Browser Extender will be able to execute templates. It will be available soon.

Greetings,
Joachim Rupik

 

[MarkP]

Hi Marco,

Re Scott's wish for a quick way to shrink the Describe Window to show only the column name.

Would it also be possible to make Describe windows work more like a conventional windows:

(1) so that I can close them quickly with CTRL+F4; and

(2) so that I can widen them quickly with ALT+Space,S or with ALT+-,S to see all of the column comment.

Kind Regards, Mark.

 

[Marco Kalter]

I have added this to the list of enhancement requests as well.