Viewing and editing data

There are two variants of displaying data: either with a command from the context menu or using an SQL query.

If you use the first variant, you should select the table you need in the Database Browser and select the Open Table command from the context menu (Fig. 4.1. Selecting the table for viewing).

All table data is displayed in a separate window in the working area of the editor. The names and order of columns corresponds to the one accepted during the description of the table structure. Data is sorted by the Primary Key assigned during the design of the table structure and work with indexes.

Fig. 4.1. Selecting the table for viewing

The displayed data can be edited. After each record is edited, table data are updated according to the rules specified in the options of the editor (see 2.2.7 Options, Fig. 2.14. Rules for updating data while editing). You should also keep in mind that these tables can be processed by triggers while being modified that is why information from the table currently displayed on the screen can differ from the actual table data.

The second variant of displaying data is based on using SQL queries directly from the window of the editor (Fig. 4.2. Selecting data with the help of an SQL query). The advantage of this method is that you can filter data both vertically and horizontally and apply any of available indexes. But it is imposible to modify data displayed with the help of an SQL query.

To create samples for various purposes, you can prepare special SQL scripts and store them on the disk. When it is necessary to display data from several tables simultaneously, it is convenient to use views.

Fig. 4.2. Selecting data with the help of an SQL query