Ctrl-` |
Launch the Command Window for SQL. Often called Ctrl-<tilde> since the tilde ~ character appears with the ` in the upper left key on US keyboards. |
Run the query. |
|
Alt-Enter |
Run the query. If text is highlighted, run only highlighted text. |
F5 |
Run the entire query. |
Shift-Alt-Enter |
Evaluate the highlighted text as an expression. |
-- |
Comment lines begin with two dashes --. |
? <expression> |
Evaluate the expression following the ?. |
!fullfetch |
Toggle more verbose information reporting on/off in the Log to include the time required, number of records involved and size of data involved. May reduce performance. |
!manifold |
For all subsequent statements use Manifold SQL and the Manifold query engine. |
!native |
For all subsequent statements use whatever is the native SQL and query engine used by the data source in which the command window was launched. |
F1 |
Launch a quick reference guide page in the browser. |
|
Query Builder |
Drag and Drop |
Add the name of a table or drawing and all fields to the Tables pane of the query builder. |
(filter boxes) |
Show only those items that contain text matching the text in the filter box, case not significant. |
Double-click |
Add this item to the query text, replacing any highlighted text. |
Right-click - Insert Definition |
When right-clicking a table name, insert SQL to create this table in the query. |
Right-click - Insert Field List |
When right-clicking a table name, insert a list of all fields in the table into the query. |
|
Edit |
Ctrl-A |
Highlight all. |
Ctrl-C |
Copy to the clipboard. |
Ctrl-X |
Cut to the clipboard. |
Ctrl-V |
Paste from the clipboard. |
Ctrl-K |
Comment the line. |
Shift-Ctrl-K |
Uncomment the line. |
Ctrl-T |
Increase line indent. |
Shift-Ctrl-T |
Decrease line indent. |
Ctrl-U |
Make selected text lower case. |
Shift-Ctrl-U |
Make selected text upper case. |
Arrow keys |
Move the cursor in the direction of the arrow. |
Page Up / Down |
Move the cursor one window up or down. |
Home |
Move the cursor to the left-most character of the current line. |
End |
Move the cursor to the right-most character of the current line. |
Ctrl-Home |
Move the cursor to the first line. |
Ctrl-End |
Move the cursor to the last line. |
Ctrl-F |
Edit - Find |
Shift-F3 |
Edit - Find Previous |
F3 |
Edit - Find Next |
Ctrl-H |
Edit - Replace |
Ctrl-] |
Move cursor to matching bracket. Available when cursor is next to a bracket. <>, [], (), {} match across lines. #, ' and " match within same line only. |
Shift-Ctrl-] |
Move cursor to matching bracket and select all in between, inclusive. Available when cursor is next to a bracket. <>, [], (), {} match across lines. #, ' and " match within same line only. |