VistaDB 6
VistaDB / Tools User's Guide / Data Builder / Context Sensitive Screens / SQL Query Pane / Keyboard Shortcuts
In This Topic
    Keyboard Shortcuts
    In This Topic

    Keyboard, Menu, and Toolbar

    The SQL Query window supports a number of shortcut keys, and most of these options have menu and toolbar equivalents as well.

    Execute Query - F5 or Ctrl-E

    Run the current command. You may run a partial command in the pane by selecting it with the cursor. Only the highlighted part of the command will be executed.

    SQL History F6

    Brings up a dialog that allow you to view recent command history. This history is kept in the vdc4 file beside the database. This config file may be deleted and is not required for database operation.

    Clear Results F7

    Clears the results from the lower pane to free resources.

    New Query F8

    Clears the command from the Query Expression. Any existing query will be lost if not saved first.

    Open Query F9 - Ctrl-O

    Open a previously saved query from disk (VSQL6 files).

    Save Query F10 - Ctrl-S

    Save the current file in the editor, or prompt you to save as a new file if the sql is a new file. The editor control will convert all changes in the file since loading to green. Yellow changes are changes made since the last save of the file.

    Select All Ctrl-A

    Select all the text in the query editor.

    Goto Line Ctrl-G

    Goto a specific line in the editor. If the line is currently collapsed it will expand the node automatically.

    Find / Replace Ctrl-F

    Find and replace functionality including incremental search. Searches can be performed for words, partial words, regex expressions and more.

    Print Ctrl-P

    Display the print dialog and then print the current sql query to the printer.

    Delete to end of word - Ctrl-Del

    Deletes to the end of the current word.

    Navigate to previous word Ctrl-Backspace

    Go backward in document to previous word.

    Cut Line Ctrl-L

    Cut current line to the clipboard.

    Undo Ctrl-Z

    Undo last made edit. Undo buffer can grow almost unlimited in size. Only way to clear the undo buffer is to open a new document.

    Redo - Ctrl-Y

    Redo (if available) the last undo operation.

    See Also