Data Port Console
Getting Started Tutorial: Viewing table data
Table data can be viewed using three different mechanisms:
- Table browser - The table browser allows a very fast read-only access to table data. You can use it to quickly browse the table data.
- Table grid - Besides displaying table data, the table grid also allows you to edit it in place. If the table contains images they will be displayed.
- Query editor -
The query editor allows you to execute SQL queries against the selected database.
Table browser
You can access the table browser view either from the Data Explorer pane or from a database diagram view. From the Data Explorer pane, select the table you want to browse and right-click it to show the context menu:
The resulting view will be similar to this:
Please note that the table browser is read-only so there is no way to edit table data from thie view.
You can also open the table browser from the diagram editor. Just select the table you want to browse and by right-clicking on the columns list you will also display the same context menu:
Table grid
The table grid view is accessed the same way as the table browser - through the table context menu. When the context menu shows up, select the Open option. The table grid view looks quite different from the browser:
Unlike the table browser, the grid loads all the table data to memory so it will be slower to load but allows you to edit the data. New rows can be inserted (just start typing on the last row), old rows can be deleted (click on the row handle and press the Del key) and existing data can be changed (directly change the data in the cell you like). There are a few important issues to note:
- The grid works by default in delayed update mode. Any change that you make to the data will not be immediately committed to the database unless you select the automatic commit option (yellow database with black triangle on toolbar). Delayed update mode allows you to discard all the changes to the table by not committing them when you close the grid.
- When in delayed update mode, use the save button to committ all changes to the database.
- The grid changes are committed in a transacted mode so that if any error occurs, no changes are made to the database.
- Edits can be filtered so you can accurately see which rows you inserted, updated or deleted.
Query editor
The Query editor is explained in the next section.
Next: Executing SQL queries
Previous: Opening a database
|
