If a column is suitable for entering multiple values, you will see extra icons next to the input field.
Figure 12: Entering multiple values
Icon | Meaning |
---|---|
|
Insert data. A separate input form opens. |
|
Delete data. |
If a column is suitable for entering multiple values, you will see extra icons next to the input field.
Figure 12: Entering multiple values
Icon | Meaning |
---|---|
|
Insert data. A separate input form opens. |
|
Delete data. |
Use the slider to set a value within a defined range. The value appears next to the slider and can be displayed in full with the tooltip. The color indicates how critical the value is assessed to be.
Figure 13: Slider
To switch to advanced mode
Press Ctrl + Alt + Enter or click the button at the bottom right.
Figure 14: Directly entering a database query
Icon | Meaning |
---|---|
|
Quits advanced edit mode. |
|
Undoes last change. |
|
Redoes last change. |
|
Cuts selected code. |
|
Copies selected code into clipboard. |
|
Inserts code from clipboard. |
|
Deletes selected code. |
|
Decreases insert. |
|
Increases insert. |
|
Automatic text formatting. |
|
Formats text selection automatically. |
|
Shows/hides line numbers. |
|
Inserts comments. |
|
Removes comments. |
|
Inserts or removes line numbers. |
|
Inserts or removes automatic line breaks. |
|
Shows or hides spaces and tabs. |
|
Searches within code. |
|
Inserts code snippet. |
|
Shows list of objects properties. |
|
Shows auto completion list. |
|
Shows list with parameter information. |
|
Shows additional information. |
Shortcut |
Description |
---|---|
Ctrl + C |
Copy to clipboard. |
Ctl + Ins |
Copy to clipboard. |
Ctrl + X |
Cut and copy to clipboard. |
Shift + Del |
Cut and copy to clipboard. |
Ctrl + L |
Cut row and copy to clipboard. |
Ctrl + V |
Paste from clipboard. |
Shift + Ins |
Paste from clipboard. |
Ctrl + Y |
Redo action. |
Ctrl + Shift + Z |
Redo action. |
Ctrl + Z |
Undo action. |
Backspace |
Remove character behind cursor. |
Shift + Backspace |
Remove character behind cursor. |
Ctrl + Backspace |
Remove word behind cursor. |
Del |
Delete character in front of cursor. |
Ctrl + Shift + L |
Delete row. |
Ctrl + Del |
Delete to end of next word. |
Data |
Insert line break. |
Shift + Return. |
Insert soft line break. |
Ctrl + Return |
Insert row above. |
Ctrl + Shift + Return |
Insert row below. |
Ctrl + Space |
Auto-complete. |
Ctrl + Space + Space |
Show list with parameter information. |
Tab |
Insert indent/tab. |
Shift + Tab |
Remove indent/tab. |
Ctrl + U |
Change marked characters to lowercase. |
Ctrl + Shift + U |
Change marked characters to uppercase. |
Ins |
Toggle insert mode. |
Ctrl + T |
Swap characters in front and behind cursor. |
Ctrl + Shift + T |
Swap words in front and behind cursor. |
Shift + Alt + T |
Swap row with previous row. |
Alt + PgUp |
Move row up. |
Alt + PgDn |
Move row down. |
PgUp |
Move up |
PgDn |
Move down. |
Left arrow |
Move left. |
Right arrow |
Move right. |
Ctrl + Left arrow |
Move to previous word. |
Ctrl + Right arrow |
Move to next word. |
Home |
Move to start of line. |
End |
Move to end of line. |
Ctrl + Home |
Move to start of script. |
Ctrl + End |
Move to end of script. |
PgDn |
Move up a page. |
PgUp |
Move down a page. |
Ctrl + PgUp |
Move to visible start. |
Ctrl + PgDn |
Move to visible end. |
Ctrl + ] |
Move to next bracket. (not possible on German keyboard) |
Ctrl + Down arrow |
Scroll down. |
Ctrl + Up arrow |
Scroll up |
Ctrl + F |
Open search dialog. |
F3 |
Search next. |
Ctrl + F3 |
Search forward. |
Shift + F3 |
Search backward. |
Ctrl + Shift + F3 |
Find previous. |
Ctrl + H |
Replace. |
Ctrl + I |
Search forward incrementally. |
Ctrl + Shift + I |
Search backward incrementally. |
Ctrl + Shift + Num- |
Reduce code block selection. |
Ctrl + Shift + Num+ |
Extend code block selection. |
Esc |
Remove selection. |
Shift + Down arrow |
Extend selection down. |
Shift + Up arrow |
Extend selection up. |
Shift + Left arrow |
Extend selection left. |
Shift + Right arrow |
Extend selection right. |
Ctrl + Shift + Left arrow |
Extend selection to previous word. |
Ctrl + Shift + Right arrow |
Extend selection to next word. |
Shift + Home |
Extend selection to start of line. |
Shift + End |
Extend selection to end of line. |
Shift + Alt + Home |
Extend selection to start of script. |
Ctrl + Shift + End |
Extend selection to end of script. |
Shift + PgUp |
Extend selection by one page up. |
Shift + PgDn |
Extend selection by one page down. |
Ctrl + Shift + PgUp |
Extend selection to visible start. |
Ctrl + Shift + PgDn |
Extend selection to visible end. |
Ctrl + A |
Select all. |
Ctrl + Shift + W |
Select word. |
Ctrl + Shift + ] |
Select up to the next bracket. (not possible on German keyboard) |
Shift + Alt + Down arrow |
Extend selected block down. |
Shift + Alt + Up arrow |
Extend selected block up. |
Shift + Alt + Left arrow |
Extend selected block left. |
Shift + Alt + Right arrow |
Extend selected block right. |
Ctrl + Shift + Alt + Left arrow |
Extend selected block by one word to the left. |
Ctrl + Shift + Alt + Right arrow |
Extend selected block by one word to the right. |
Ctrl + mouse wheel |
Adjust text size. |
There is additional help provided for creating script code.
The input fields support syntax highlighting depending on the syntax type.
You can use auto-completion when you write script code. The amount of scripted code to enter is reduced by displaying the names of properties or functions that can be used. To use auto-completion, use the shortcut Ctrl + SPACE in the relevant positions within the input fields. The contents of the list is determined by the key words in the code.
Select the icon.
Select the code snippet.
Press F2.
Select the code snippet.
Using an aliases
Use Tab to insert the code snippet.
NOTE: If you select a code snippet directly using a shortcut or the icon, a short description and the shortcut name are displayed in a tooltip.
In input fields where a VB.NET term is expected, a help list opens when you enter $. All properties of the current object are displayed. You can also see a tooltip with a detailed description of the property. When you select a foreign key (FK) column, you can navigate to the columns in the relevant table using the arrow keys. To end the selection in the target column, press Enter or double-click. The complete $ notation for your selection should now be shown in the input column. To close the help list without copying any data, press Esc or leave the input field.
Figure 15: Help list for dollar notation
Icon | Meaning |
---|---|
|
Property of current object. |
|
Primary key (PK). |
|
Foreign key (FK). |
|
Dynamic foreign key |
|
Table |
|
Special properties |
|
Script |
Shortcut | Action |
---|---|
Arrow down key |
Opens the help list. |
Arrow up key, arrow down key |
Navigate to previous or next entry. |
Arrow left key, arrow right key |
Navigate to the object above or below over the foreign key. |
Data |
Accepts the value in dollar notation. |
It is sometimes necessary to enter database queries. You can enter the database queries as a SQL query directly or compile the database queries with a wizard. Use the , or buttons to switch to the appropriate view.
Icon | Meaning |
---|---|
|
Enter a database query as a SQL query. |
|
WHERE clause wizard. |
|
Filter designer. |
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center