Query Editor Keyboard Shortcuts

1. Press Ctrl-Alt-T to change the focus to the Outline window.
    
   
2. Press Tab, down arrow. The first item in the list under Page1 is highlighted.
    
   
3. Press the down arrow key to go to the last item in the list.
    
   
4. Press Tab, down arrow. The focus changes to the first item in the next section.
    
   
5. Continue to scroll through the Outline window until you highlight a rowset.
    
   
6. Press Shift-F10. The pop-up menu opens and Edit SQL Statement is highlighted.
    
   
7. Press Enter. The Query Editor opens with the focus in the SQL pane.
    
   

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

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

• Press Alt-1 to change the focus to the diagram pane. If you change the focus to the diagram pane, you cannot use keyboard shortcuts to make changes in the pane. Instead, edit in the grid pane or SQL pane.
   
  
• Press Alt-2 to change the focus to the grid pane.
   
  
• Press Alt-3 to change the focus to the SQL pane.
   
  
• Press Alt-4 to change the focus to the results pane.
   
  

With the focus in the SQL pane of the Query 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.
   
  
• Press Ctrl-C to copy text, Ctrl-X to cut text, or Ctrl-V to paste text.
   
  

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

1. Press Shift-F10.
    
   
2. Press the down arrow key to select Run Query.
    
   
3. Press Enter to start the query.
    
   

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

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

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

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

1. Press Alt-2 to change the focus to the grid pane.
    
   
2. Press Shift-F10 to open the Add Query Criteria dialog box.
    
   
3. In the Add Query Criteria dialog box, press the Tab key to select the field you want to edit.
    
   
4. When you are finished with your edits, press Enter to save the query.
    
   

• Press Shift-F4.