Visual SQL Editor Keyboard Shortcuts

See Also

This topic describes how to use the keyboard shortcuts to work with the Visual SQL Editor.

To perform this task... Follow these steps...
Open the Visual SQL Editor
  1. Change the focus to the .
  2. Scroll through the Navigator window until you highlight a rowset.
  3. Press Shift-F10. The pop-up menu opens and Edit SQL Statement is highlighted.
  4. Press Enter. The Visual SQL Editor opens with the focus in the SQL pane.

You can use keyboard shortcuts to go to different panes in the Visual SQL Editor. Most tasks, except refining a query, can be completed in the SQL pane of the Visual SQL Editor.

Workaround: If you cannot open the Visual SQL Editor by following the instructions, you can use the mouse and right-click a rowset in the Navigator window. Select Edit SQL Statement in the pop-up menu, and press Enter.

Enter and edit SQL code

With the focus in the SQL pane of the Visual SQL Editor:

  • Press the up arrow or down arrow keys to move the cursor.
  • To select a string, hold the shift key and use the left arrow or right arrow keys to select the entire string.
Test an SQL query

With the focus in the SQL pane of the Visual SQL Editor:

  1. Press Shift-F10.
  2. Press the down arrow key to select Run Query.
  3. Press Enter to start the query.
The results pane of the Visual SQL Editor shows a representation of the results after you run a query.
Parse an SQL query

With the focus in the SQL pane of the Visual SQL Editor:

  1. Press Shift-F10.
  2. Press Enter to parse the query.

The diagram pane and grid pane of the Visual SQL Editor are updated after you parse a query.

Refine your SQL query

With the focus in the grid pane of the Visual SQL Editor:

  1. Press Shift-F10 and Enter to open the Add Query Criteria dialog box.
  2. In the Add Query Criteria dialog box, press the Tab key to select the field you want to edit.
  3. When you are finished with your edits, press OK to save the query.
Close the Visual SQL Editor
  • Press Shift-F4, select the document you want to close, and click Close.
See Also
Supported SQL Queries
Creating an SQL Query
About the SQL Pane

Legal Notices