Toad World® Forums

Activity context of ESC key and undo action


#1

Greetings guys,

I’m not sure if this is something to fix, but definitely something to consider. Here are a couple of things I’m running into:

  1. I’m working in the procedure or entity editor. I click on a drop down list to select an item, and then decide not to change the value. I hit the ESC key and the entire entity or stored procedure window closes. To my knowledge, standard Windows OS behavior is to simply “close” the drop down list so that the options are no longer being displayed.

  2. I open the entity editor for a table and change the order of some of the columns in the table. I click OK to apply the changes and close the window. I then double on a procedure I’ve created and go to the SQL tab. I start making some changes to the SQL code, when I realize I made a mistake and want to change undo a bit of my recent text. I Hit CTRL+Z to undo the text edit, but notice that the order of the columns in the table is now back to the original order before I made my changes.

Both of these activities has occurred to me on several occasions and has lost me a decent amount of work, since I didn’t immediately save after making a change to a table or a procedure.

Keep up the great work guys!!!


#2

Hello Dillie-O,

Thanks very much for your post!

AD 1 - This is a bug. We will fix it. CR # 52 920.

AD 2 - Undo always returns to the action that was last confirmed OK or Apply. (In other words, Undo always returns the last commited operation.) So, when you start making some changes to the SQL code, confirm the changes continuously via Apply. When you realize you made a mistake, press Cancel.

If you have any questions, please write us back. Thanks!

Regards,

Vladka


#3

Hi,

re AD 2 - It would be useful to have a more caapable text editor.

It should allow undo (in a similar way to other apps). A find/replace would also be very helpful.

Regards
Malcolm


#4

Hi Malcolm,

in your Procedure, on tab SQL, please try the following:

  1. UNDO: instead of hitting CTRL+Z, right click the are and select Undo.
  2. Find/Replace: Press CRTL+R.

Regards,

Vaclav


#5

Hi Vaclav,

that’s quite helpful thanks
but…

  1. Undo takes you back to the start of the Text Editor session, even if you have done Apply. I would expect it to only undo to the last Apply.

  2. I was expecting Ctrl+F for find.

Regards
Malcolm


#6

Hi Malcolm,

I agree the Undo functionality should work better. There seems to be some bug. I created new CR for this: #53067

And I also agree that CRTL+F is more intuitive as CRTL+R aligns text in Text editors to right. This will be changed. CR# 53068.

Thanks again for your feedback.

Regards,

Vaclav


#7

Hi Vaclav,

TOAD for Oracle uses;
Ctrl+F for find
Ctrl+R for replace

Alternatively MS use;
Ctrl+F for find
Ctrl+H for replace

Take your pick

Regards
Malcolm


#8

OK,

thanks :slight_smile:

Vaclav


#9

Hi Vaclav,

Right-click and Ctrl+R don’t work in the Package Editor SQL dialog

Malcolm


#10

Hi Malcolm,

yes, you are right. New CR#53182 was created. :slight_smile:

Regards,

Vaclav