Standard form for operations with tables

Print Previous page Top page Next page

ici_9111 Standard form (SF) is intended for displaying and editing data of DB tables.

 

SF can work in modes:

Browse tables tree. Structure of tables tree of SF is set by user in Standard form bookmark of Base Administrator. In this tree the user can set at once some master and detail tables. For activation of SF press Show button.

Browse separate table. Activation of SF is realized with the help of Browse button located in Standard form bookmark, or in Tables bookmark of Base Administrator.

After activation SF has:

- the main window;

- the main menu;

- the panel of access to data table;

- the link panel of map and data table.

 

Window "Standard form for working with tables":

 

_bm5029

 

Name (file location) of active map is shown in the line of SF heading.

Main window serves for data presentation in a tabular kind and looks similarly to a spreadsheet.

Main menu, Access panel (it is under the main menu), Link panel (it is in the left part of the main window) contain a set of commands and buttons which allow to look through and to edit  data, and also to adjust view of the shown data.

The panel of link of a map and the table of data contains the following command buttons:

- link current record with the chosen map object;

- find the map object, linked with the current record in a database;

- find record in a database, linked with current map object;

- mark all the objects connected with accessible records;

- show records for the marked objects (type of link is internal one, or by semantics);

- reset of the marked objects;

- saving data to a CSV file.

In the right part of Access panel there is a window which contains the list of indexes. The current index is selected of the indexes list which have been set at creation of the table. More often indexes are defined at creation of the table and during work with the table do not change. However the user has an opportunity to change indexes, defined for the table, with help of Structure  command button in the Table bookmark of Base Administrator.

In SF the following functions are accessible:

- open data table;

- close the current data table;

- create data table;

- browse properties of the current data table;

- open for browsing the detailed table for the current data table;

- rename the current data table;

- delete the current data table;

- Navigation on records of table;

- delete record in current table;

- add record into current table;

- cancel changes in current record;

- save changes in current record;

- To filter (to find) records in current table;

- define displaying order of records in the current table by choice of index;

- change structure of the table;

- call BDE administrator or ODBC administrator;

- link the current record with the chosen map object;

- find map object linked with the current record in a database;

- find record in a database, linked with the current map object;

- select all objects linked with accessible records;

- drop of selected objects, linked with records;

- call of geocoding function;

- call of function of auto link;

- print report on the data table.