Switch between Script Results from keyboard

Toad Data Point & Toad Intelligence Central
1

Hi ,

Is there any way to switch between result sets from keyboard? Wasn’t able to find anything in Options\Keyboard and Help. Can you please create an enchancement for this in case of absence?

thanks in advance,

Alex

2

Hi Alex,

It’s a very good question!

Unfortunately there is no way to switch between result sets from SQL Editor. If you select a result tab then you can use right/left arrows to switch between the results.

I created the enhancement request QAT-1070.

Regards

Aleksey

3

Hi Alex,

It looks like the following key combination works!

From the Sql Editor press

  • F6
  • Shift + Tab <-- Note: Will not work if the first cell is not the current active cell.
  • Left/Right Arrows

To return back to the editor press F6 again.

Regard

Aleksey

4

Hi Aleksey,

seems like a solution for me. Thanks!

Just so you know, when I called F6 at first try it threw an exception - see stack trace below. No such exception on the same connection/file after TDP restart. I’m on TDP 3.4.0.1883 Beta.

Also, from what I got later - F6 stops switching me to the Result Sets grid after I undock-dock Editor document. Seems like a bug :slight_smile:

Alex

System.NullReferenceException

Stack Trace:

в ActiproSoftware.UIStudio.Dock.ToolWindow.Activate(Boolean focus)

в Quest.Toad.Editor.EditorForm.toggleFocus()

в Quest.Toad.Editor.EditorForm.EditorForm_KeyDown(Object sender, KeyEventArgs e)

в System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)

в Quest.Toad.Gui.DocumentForm.MainForm_KeyDown(Object sender, KeyEventArgs e)

в System.Windows.Forms.KeyEventHandler.Invoke(Object sender, KeyEventArgs e)

в SystemObject sender, KeyEventArgs e)

в System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)

в System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)

в System.Windows.Forms.Form.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Control.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Form.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Control.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Control.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Control.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Control.ProcessKeyPreview(Message& m)

в System.Windows.Forms.Control.ProcessKeyMessage(Message& m)

в System.Windows.Forms.Control.WmKeyChar(Message& m)

в System.Windows.Forms.Control.WndProc(Message& m)

в System.Windows.Forms.ScrollableControl.WndProc(Message& m)

в ActiproSoftware.SyntaxEditor.SyntaxEditor.WndProc(Message& m)

в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

5

Hi Alex,

Thanks for reporting the exception. We’ll look at it.

Thanks again

Aleksey