Command Window - SQL

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.