General information

 Print Previous page Top page Next page

mapdba_icon «Information from the database table» dialog is intended for viewing the attributes of objects from external data sources. Such sources may be:

- spatial database from which the DBM-map is opened;

- a web service of the «1C Enterprise» program that publishes its data sets via the http protocol (including those with support for the OData protocol);

- other web services publishing their attribute data sets via the http protocol.

 

Viewing attributes of objects from external sources of data is available for DBM maps and user maps for which customizing the receiving the attributes of objects from external sources has been made.

To open the «Information from the database table» dialog, click on the «View external attributes» button located on the main toolbar, and then select an object on the map.

Dialog «Information from the database table» will be as a result displayed which allows you to perform the following functions:

-   find a map object for the current record;

-   show information about the object for the current record;

-   select related objects;

-   show records for selected objects

-   show detailed information for the current record;

-   navigation through table records;

-   editing table records;

-   search, filtering, sorting of data;

-   saving data to a CSV file.

 

If parameter «Field of unique identifier» is not set in the «Parameters of representation of a spatial database» of the DBM-map, in dialog only modes of display and editing of the table records are available.

For fields like ftGraphic, ftMemo, ftWideMemo, the values ​​are viewed and edited in an additional window, which is invoked by double-clicking the left mouse button on a table cell.

The dialog provides tools for convenient viewing of a table with a large amount of data:

-   setting the order of displaying columns;

-   changing the width of columns;

-   specifying the status of columns visibility.

 

The list of visible columns is customized by clicking on the upper left cell (with the image of a black triangle pointing down), as a result a menu with a list of table fields will be displayed, by selecting which you can show/hide columns.

Database table display parameters are saved in a file with the name of the corresponding vector map and the extension «*.dbmi», for example,

c:\Users\Public\Documents\Panorama\publicfacil.dbmi.