The window serves for browsing and editing a table or a query.
The pane contains names of fields (columns) of the query being browsed. The following operations can be performed with selected fields: renaming a field, changing width, hiding and so on.
Multiple selection of fields is possible. To reset selection it is enough to click in the table pane.
All operations except for rearranging fields can be performed using the context menu or items of the menu Fields.
Changing order of fields is performed by dragging selected field (or fields) while holding down the left mouse button. In the course of dragging the cursor takes the form 
or 
depending on whether locating table field is allowed in this place or not.
The pane permits selecting records (rows) of the browsed query. It is possible to perform different operations with selected records. To perform required operation one can use context menu or items of the menu Records.
Multiple selection of records is possible. To reset selection it is enough to click any mouse button in the table pane.
The table pane is intended for browsing and editing table records. One can select any table record by clicking the left mouse button by analogy with selecting a line in a list pane.
Record fields are located at intersection of rows (records) and columns (fields). To find the necessary record and/or field it is possible to use scroll bars.
When browsing a table it is possible to edit separate fields of table records. To edit a field it is required to click on this field.
Current information about displayed query is shown in the status bar: total number of records, number of selected records, order of displaying records, etc.
Permits replacing the browsed query (or table) by another cataloged query. If internal table or query of GDB is browsed, any internal query can be selected for replacement. If the table or query of EDB is browsed, only another query from the same EDB can be selected. | |
Allows saving changes made into the method of forming the browsed query. If the query is non-cataloged, the command is equivalent to the command Save As. | |
Permits creating a new cataloged query. | |
Permits performing the operation of copying a query. | |
Allows performing the operation of merging a query and a table. | |
Permits performing the operation of exporting a query to text or DBF file. | |
Permits printing a query. | |
Opens a property sheet “Properties of query” which contains information about properties of the browsed query: search condition, calculated fields, sorting, etc. | |
Serves for closing table browser window. |
Serves for browsing and editing selected record. When performing this command a window of editing records is opened. | |
Serves for adding records. | |
Serves for removing selected records. | |
Allows going to the record having specified the number indicated in the pane of record numbers of table browser window. | |
Permits going to the group of previous (or next) selected records which are not seen in the browser window. | |
Allows inverting the set of selected records. |
Permits changing field name in table browser window. | |
Allows changing field width in table browser window. | |
Permits disabling display of fields in table browser window. | |
Allows enabling display of fields which were hidden before. | |
Permits disabling or enabling changing field values. | |
Allows setting a reference table for a field or resetting usage of the reference table for a field. | |
Permits viewing, setting and changing calculated fields for table field. | |
Allows removing the calculated field. The command is enabled only for the calculated field. | |
Permits getting total information by field values in all records of the table or in selected ones. | |
Serves for performing the operation of joining tables by selected field. |
Permits specifying condition of searching records and getting the query containing records satisfying this condition. | |
Allows performing setting of control elements. |
Serves for turning on/turning off window toolbars and also permits performing setting of window control elements. | |
Serves for turning on/turning off display of the window status bar. | |
Turns on and turns off the mode of fast scrolling of records. | |
Causes update of window contents. |
Permits opening a new table browser window which contains the same data as the present one when the latter is created. |
| Command Query+Open |
| Command Query+Save |
| Command Query+Print |
| Command Query+Properties |
| Command Tools+Search |
| Command Records+Open |
| Command Records+Add |
| Command Records+Remove |
| Commands Records+To Previous Selected and Records+To Next Selected |
 |  |
