Data Frame

Data can be displayed as a grid, as a form, or as a printable report. To change the view mode click one of the buttons at the bottom of the area: Grid View, Form View, or Print Data.

Grid View

View data as a grid. The columns correspond to the fields and rows correspond to the records. Clicking the column caption sorts data by the values of this column in the ascending or descending mode. The navigation bar allows you to switch the records quickly, insert, update or delete records. You can filter the current data view using drop-down arrows at the right of the column captions.

Clicking the right mouse button in the window area activates popup, which allows you to call the Export Data Dialog, Export Data As INSERT Dialog, Import Data Wizard (for tables only)

The following functions are also available: Quick Copy To Clipboard, set the field value as Null, clear string (for text fields), edit BLOB (for BLOB fields; see BLOB Viewer/Editor) and set the DATE, TIME or DATETIME field to the current date and time ('Set To Now' item).

Form View

View data as a form. On the form a current record is displayed: field name and its value. If these data are available for editing, you can do it on this form. The navigation bar allows you to switch the records quickly, insert, update or delete records.

Each field has a Null switch, which allows you to clear the field value quickly; near each number field a calculator button is placed (calculator field automatically fills in the current field); near each date field calendar button is placed (date, selected in the calendar, automatically fills in the current field).

Print Data

Data are displayed in the way they are printed, in WYSIWYG mode. Using button on the toolbar you can change the view scope, save the report to file and set the page printing parameters.

The status bar displays the number of records in the current data set.

See also:

Table Editor SQL Editor Visual Query Builder