|
Multiple record mode |
Single record mode |
Up Arrow |
Move to the previous row. In Select Group of Records mode, select it. |
Move to the previous field. |
SHIFT + Up Arrow |
In Select Group of Records mode, select the previous row without deselecting the current one. |
|
CtrL + Up Arrow, CtrL + Page Up |
Move to the first row in the grid. Deselect any selected rows. |
Move to the first field. |
Down Arrow |
Move to the next row. In Select Group of Records mode, select it. |
Move to the next field. |
SHIFT + Down Arrow |
In Select Group of Records mode, select the next row without deselecting the current one. |
|
CtrL + Down Arrow, CtrL + Page Down |
Move to the last row in the grid. Deselect any selected rows. |
Move to the last field. |
Page Up |
Move up by the number of records shown in the grid. Deselect any selected rows. |
Move up by the number of fields shown in the grid. |
SHIFT + Page Up |
In Select Group of Records mode, select up the number of records shown in the grid. |
Move up by the number of fields shown in the grid. |
Page Down |
Move down by the number of records shown in the grid. Deselect any selected rows. |
Move down by the number of fields shown in the grid. |
SHIFT + Page Down |
In Select Group of Records mode, select down the number of records shown in the grid. |
Move down by the number of fields shown in the grid. |
Left Arrow |
Move left one column. In Select Group of Records mode, move to the previous row without selecting it. |
|
CtrL + Left Arrow |
Move to the first column in the current row. |
|
Right Arrow |
Move right one column. In Select Group of Records mode, move to the next row without selecting it. |
|
CtrL + Right Arrow |
Move to the last column in the current row. |
|
Home |
Move to the first column of the current row. In Select Group of Records mode or the grid has only one column, move to the first record in the dataset. Deselect any selected rows. |
|
CtrL + Home |
Move to the first record in the dataset. Deselect any selected rows. |
Move to the first field. |
SHIFT + Home |
In Select Group of Records mode, move to the first record in the dataset and select all rows between the current and the first ones. |
|
End |
Move to the last column of the current row. In Select Group of Records mode or the grid has only one column, move to the last record in the dataset. Deselect any selected rows. |
|
CtrL + End |
Move to the last record in the dataset. Deselect any selected rows. |
Move to the last field. |
SHIFT + End |
In Select Group of Records mode, move to the last record in the dataset and select all rows between the current and the last ones. |
|
Tab |
Move to the next cell in the grid. |
Move to the next field. |
SHIFT+ Tab |
Move to the previous cell in the grid. |
|
CtrL + Delete |
Delete the current selection. |
|
Insert |
Insert a new row above the current one, and move to it. Deselect any selected rows. |
Insert a new record in the table, and move to it. |
Escape |
Cancel any unposted edits. Deselect any selected rows. |
Cancel any unposted edits. |
F2 |
Put the current cell in edit mode. |
Put the current cell in edit mode. |
CtrL + SHIFT + 0 |
Set bookmark on current row. |
|
CtrL + 0 |
Go to bookmark. |
|
CtrL + mouse wheel |
Like Page Up, Page Down. |
|
SHIFT + mouse wheel |
Increase / decrease row heights. Use for viewing long text (including MEMO) or graphic data. CtrL + Add/Subtract keys (numeric keypad) does the same. |
|
Mouse wheel click |
Move to the auto-scrolling mode. |
|
CtrL + F5 |
Copy value of selected field, move to next record and then set the value of selected field to copied value. |
|
CtrL + I, CtrL + ALT + I |
Copy value of selected field, move to next record and then set the value of selected field to copied value, incremented by 1 (CtrL + I) or by custom number (CtrL + ALT + I). |
|
CtrL + ALT + V |
Paste cells from clipboard starting from current cell. Carriage return character is used to separate rows and a tab character is used to separate columns. This function is useful to paste tabular data, which was previously copied in Exportizer or other application (for example, Microsoft Excel). |
|
CtrL + H |
Hide current column. |
|
CtrL + ALT + H |
Show all columns. |
|
CtrL + C |
Copy text of selected cell. |
Copy text of selected cell. |
CtrL + V |
Paste text from clipboard to selected cell. |
Paste text from clipboard starting from selected cell. |
CtrL + X |
Cut text to clipboard from selected cell. |
Cut text to clipboard from selected cell. |
F9 |
Execute query (queries): either selected (if there is a selected text fragment in the editor) or all SQL (if there is no selected text fragment) |
F8 |
Execute current query. Current query is the query between SQL terminators (if any) containing the current caret position. |
Ctrl + F9 |
Execute query from the editor until SQL terminator is found. |
ALT + Left Arrow |
Load previous SQL text from SQL history |
ALT + Right Arrow |
Load next SQL text from SQL history |
CTRL + L |
Load SQL text from file |
CTRL + S |
Save SQL text to file |
Up Arrow |
Up |
SHIFT + Up Arrow |
Select Up |
CTRL + Up Arrow |
Scroll up |
Down Arrow |
Down |
SHIFT + Down Arrow |
Select Down |
CTRL + Down Arrow |
Scroll Down |
Left Arrow |
Left |
SHIFT + Left Arrow |
Select Left |
CTRL + Left Arrow |
Move Left to the next word |
CTRL + SHIFT + Left Arrow |
Select word to the left |
Right Arrow |
Right |
SHIFT + Right Arrow |
Select Right |
CTRL + Right Arrow |
Move Right to the next word |
CTRL + SHIFT + Right Arrow |
Select Word to the right |
Page Down |
Page Down |
SHIFT + Page Down |
Select Page Down |
CTRL + Page Down |
Page Bottom |
CTRL + SHIFT + Page Down |
Select Page Bottom |
Page Up |
Page Up |
SHIFT + Page Up |
Select Page Up |
CTRL + Page Up |
Page Top |
CTRL + SHIFT + Page Up |
Select Page Top |
Home |
Line Start |
SHIFT + Home |
Select to Line Start |
CTRL + Home |
Editor Top |
CTRL + SHIFT + Home |
Select to Editor Top |
End |
Line End |
SHIFT + End |
Select to Line End |
CTRL + End |
Go to Editor Bottom |
CTRL + SHIFT + End |
Select to Editor Bottom |
Insert |
Toggle Insert mode |
CTRL + Insert, CTRL + K + C, CTRL + C |
Copy selected text to Clipboard |
SHIFT + Insert, CTRL + K + V, CTRL + V |
Paste text from Clipboard |
Delete |
Delete |
SHIFT + Delete, CTRL + K + Y, CTRL + X |
Cut text to Clipboard |
Backspace, CTRL + Backspace |
Delete Last Character |
CTRL + Backspace |
Delete Last Word |
CTRL + Z, ALT + Backspace |
Undo |
CTRL + SHIFT + Z, ALT + SHIFT + Backspace |
Redo |
Return, CTRL + M |
Line Break |
CTRL + A |
Select All |
CTRL + SHIFT + I, CTRL + K + I |
Block Indent |
CTRL + N |
Insert line |
CTRL + T |
Delete word |
CTRL + SHIFT + U, CTRL + K + U |
Block Unindent |
CTRL + Y |
Delete line |
CTRL + SHIFT + Y |
Delete to the end of line |
CTRL + SHIFT + 0..9 |
Set / clear bookmark 0..9 |
CTRL + 0..9, CTRL + K + 0..9 |
Go to bookmark 0..9 |
CTRL + SHIFT + N, CTRL + O + K |
Set normal selection mode |
CTRL + SHIFT + C, CTRL + O + C |
Set column selection mode |
CTRL + SHIFT + L, CTRL + K + L |
Set line selection mode |
CTRL + SHIFT + B |
Find matching bracket (caret must be set just before bracket) |
CTRL + / |
Comment or uncomment the current selection |
Double click on the word |
Select the word |
Click on the left part of the gutter |
Set / remove bookmark |