4.2.2.1.1. A simple list of data
List of data not directly related to the database, which displays the data in static mode and program memory.
These functions are:
| Shortcut | Popup menu | Description |
|---|---|---|
| Ctrl+I | Adjust the width of the data | Allows you to adjust the width of the columns to the data and column titles. The width is calculated on the basis of 50 rows below the highlighted line. |
| Shift+Right | Increase the width | ncreases the width of the selected columns by 10 points on screen (pixels), not more than 1000 |
| Shift+Left | Reduce the width | Reduces the width of selected columns by 10 points on screen (pixels), not less than 30 |
| Shift+Down | Increase the row height | Increases the height of the selected line of 10 points on screen, no more than 150 |
| Shift+Up | Reduce the height of a row | Reduces the height of the selected line of 10 points on screen, no less than the original amount thereof. |
| Alt+Right | Move the column to the end | Allows you to move the currently selected column at the end of the list. |
| Alt+Left | Move the last column in this place | Allows you to move the last column of the list in place of the currently selected. |
| Ctrl+C | Copy value to clipboard | Allows you to copy the value of the currently selected field to the clipboard of the operating system. |
| Export | A set of commands to export data from the list. These commands depend on the possession of plugins. | |
| Ctrl+E | Select a column | When you select this option, a list of list columns from which you can choose the column on which you move the pointer. |
| Ctrl+End | Jump at the end of the list or at the end of some lines read from the database. | |
| Ctrl+Alt+End | Jump to end of list data, if these figures are taken from the database, all rows are retrieved. | |
| Enter | Depending on the type of list, pressing Enter will move to the next column or next line. | |
| Left, Right | Move to the left, right columns list | |
| Up, Down | Move to the line above, below | |
| Alt+A | If the list is associated with an action button, you can popup a menu of additional actions. These shares are associated with the available plugins in the program. | |
4.2.2.1.2. The main data list
All lists that are directly associated with the results of SQL commands in the program ORBADA have the same or similar functions. They are divided into lists of fixed and dynamic columns, dependent on the command of SQL statements
These functions are:
| Shortcut | Popup menu | Description |
|---|---|---|
| F5 | Refresh | Refreshes the list of data the SQL command that creates it is closed and reopened to retrieve the latest data. |
| Ctrl+I | Adjust the width of the data | Allows you to adjust the width of the columns to the data and column titles. The width is calculated on the basis of 50 rows below the highlighted line. |
| Shift+Right | Increase the width | ncreases the width of the selected columns by 10 points on screen (pixels), not more than 1000 |
| Shift+Left | Reduce the width | Reduces the width of selected columns by 10 points on screen (pixels), not less than 30 |
| Shift+Down | Increase the row height | Increases the height of the selected line of 10 points on screen, no more than 150 |
| Shift+Up | Reduce the height of a row | Reduces the height of the selected line of 10 points on screen, no less than the original amount thereof. |
| Alt+Right | Move the column to the end | Allows you to move the currently selected column at the end of the list. |
| Alt+Left | Move the last column in this place | Allows you to move the last column of the list in place of the currently selected. |
| Ctrl+C | Copy value to clipboard | Allows you to copy the value of the currently selected field to the clipboard of the operating system. |
| Export | A set of commands to export data from the list. These commands depend on the possession of plugins. | |
| Ctrl+E | Select a column | When you select this option, a list of list columns from which you can choose the column on which you move the pointer. |
| Ctrl+End | Jump at the end of the list or at the end of some lines read from the database. | |
| Ctrl+Alt+End | Jump to end of list data, if these figures are taken from the database, all rows are retrieved. | |
| Enter | Depending on the type of list, pressing Enter will move to the next column or next line. | |
| Left, Right | Move to the left, right columns list | |
| Up, Down | Move to the line above, below | |
| Alt+A | If the list is associated with an action button, you can popup a menu of additional actions. These shares are associated with the available plugins in the program. | |
| Alt+F3 | Preview... | Open an additional window with the view the value of the selected fields in detail, eg in the form of a picture, hexadecimal, etc. made available formats can be held depends on plug-ins. |
| Column properties... | Open an additional window (as above) with a preview of the fields in the form of various types of data |
4.2.2.1.3. Fixed data list
Fixed list, you can view the data. This list has a fixed list of columns defined at the level of application design. Fixed lists represent, eg database tables and their properties. These lists are not opened on the user's request, for example, after the sql command.
Column layout, width and position is remembered.
Features that extend the functionality of the class lists of all lists is:
| Shortcut | Popup menu | Description |
|---|---|---|
| Ctrl+Shift+R | Restore the original column properties | restore column layout from originally designed |
| Ctrl+V | Search by pasting from the clipboard | Allows you to find the rows list on selected column, a string located in the system clipboard |
4.2.2.1.4. Dynamic list of data
Dynamic list of data is dependent on the results made by the user (either directly or indirectly) a SQL command.
List of data stores only the width of columns and remamber it only on program runing.
The fonts and their families can be determined in the program settings.