Wishlist

[ScottMattes]

After using PLSD for the past 6 weeks, and loving 99.9% of it, I have been slowly making a list of things that would make this tool greater, at least in my mind.

These are based on my personal likes and dislikes.

Beautifier:
- I would like an option for space after ( and before ) and before & after '+-/*' .

- how about an option for the 'and' and 'or' to be before/after the line in the where clause. right now it only goes to after.

- I would like an option for align in the 'where' clause

Code Contents:
- would like the sort button to also sort the entries under the first level proc/func.

- would like it better if the browse prev/next buttons would remember the top line and restore it.

- would like it to be able to have the browse prev/next buttons on the right click menu

Editor:
- since we can right click on a unit in the code contents and 'select' it, and there is the ctl-m in the editor, how about being able to select the contents of a matched pair (begin/end, if/end if, etc)

- would like to be able to put whatever is on a menu or button on the right click menu (like 'find matching pair', etc)

- would like to be able to dbl click on a special char and have it selected

- would like ctl-left/right arrow to recognize special chars

- would like ctl-m to find the intermediate major portions of a pair ( then, else, elsif of an if/end if pair)

- how about a save bookmark option

- all find/goto tools to use an option to specify where in the editor window the line should be displayed. I almost always want them to be in the exact same spot.

- need an option to strip trailing blanks from lines.

- would like the replace dialog to report the number changed

- it would be nice to be able to jump to the 'begin' of a proc/func

- when typing a table field name, the suggetion list that pops up is not sorted, how about an option to do that

- buttons for which it matters, save is an example, enable only if it applies

- split screen in the editor would be nice

- ctl-up/down arrows don't work as in other apps, scrolling the screen without moving the insertion point

more...

------------------
------------
Scott Mattes

 

[ScottMattes]

Grids:
- would like to display a ruler in the grid, either in the header for the column or in the popup field editor

- would like all grids to sort columns if clicked on

- would like to be able to specify number format

- how about using Oracle date/time formats?

- grid cell editor needs row/col display, line nums, bookmarks

REPORTS:
- Edit Report button gave me no clues on how to refresh, though I did figure it out after awhile

- would like an option to keep the headers from scrolling

SQL WINDOW:
- can the dbms_output buffer really go over 1,000,000 bytes? the control allows it

- maybe the busy cursor should apply to the grid and its tool bar as well?

- right click menu entries need to be enabled only when they apply. do a query, click in a cell so that it isn't selected, right click and Copy is available, but it doesn't copy

TEMPLATES:
- it would be nice if a template could be made to open a window of whatever type

- it would be nice if the $query didn't execute until the drop down drops. this would allow one query to ref the value from another query

TEST WINDOW:
- option to have 'stop on next exception' position the line in a predetermined place in the window

- if profile button clicked and test window execute button clicked then say 'no debug if doing profile, OK / Cancel' instead of not doing anything. it took awhile to figure to use the far off main execute button. maybe, if profile is clicked, just start doing the profile?!?!?!

- when stepping through the code execution it would be great if there was a code contents window for easier navigating. probably other edit window stuff would be good too

VCS:
- when I click on history, diffs, the app appears on the toolbar, but doesn't appear on top, so I have to go click on it twice.

more....

------------------
------------
Scott Mattes

 

[ScottMattes]

MISC:
- in find db objects I searched for tables and views and the results came up, but didn't show what the match was for each entry

- i would like to be able to sort the items in the project items display

- for login i would like it if a check was made to see if i am already connected to the oracle specified in the project options.

- i think the describe window would benefit from a filter edit control

- being able to kill a program window when it is in a loop, instead of having to kill PLSD

- would like to be able to see LONG and SQLERRM and SQLCODE in the debugger

- question: are the compile hints from Oracle? if so, where do you get them from?

- in table view window, on index tab, want edit button for when contents are too big to fit in the display

- while it remembers what was open when shut down, it would be nice to have it remember sizing/positions/etc

- i would like the Tools / Macro items to be under the Main Menu Macro item. it is faster to access that

- how about an option to have the describe and properties windows use all available vertical space. along with options to use other amounts (4/5, 2/3, 1/2)

- print preview

- i would like to be able to order the list of open windows in the lower left area (even if it was ordered by type then name)

- goto bookmarks on the right click menu

- more API functions

Whew, done. Dispite all this, PLSD is better than any other I've seen.

------------------
------------
Scott Mattes

 

[Nashev]

Print prewiev is not useful if you have installed FinePrint (http://www.fineprint.com/products/fineprint/index.html) - that make good print preview and more other features like printing 2, 4 or 8 pages at one paper. It's really usefull.

 

[Marco Kalter]

Thank you for your feedback

Some answers to the questions:

can the dbms_output buffer really go over 1,000,000 bytes?

No, 1,000,000 is the actual maximum.

question: are the compile hints from Oracle?

No, PL/SQL code is analyzed by PL/SQL Developer.

------------------
Marco Kalter
Allround Automations

 

[ScottMattes]

I would like the current output

Function f_Is_Number(i_String In Varchar2) Return Boolean Is
v_Num Integer;

Begin

to be like this

Function f_Is_Number(i_String In Varchar2)
Return Boolean
Is
v_Num Integer;
Begin

And I would like this

Exception
When Others Then
Execution_Info_Pkg.Leaving;
Return False;
End;

to be like this

Exception
When Others
Then
Execution_Info_Pkg.Leaving;
Return False;
End;

And this

insert into tablename fields
(field1,
field2)
values
(asdf,
fdasd
);

to be

insert into tablename
fields(
field1,
field2
)
values(
asdf,
fdasd
);

Thank you for listening.

 

[Ivan C.]

I'd like to

 

[Marco Kalter]

Noted. It should indeed not be difficult.