Database administrator

Previous Top Next

The Database Administrator is intended for creation, support and usage of the DB Project.  

The window of data administrator consists of the panel with menu (Project, Edit, Forms, Service …) and some bookmarks: Data sources, User forms, Standard form, Macroses, Properties …

 

_engbm5676

 

The Project menu contains following commands:

- Open - opens projects earlier built and saved on the disk.

- Close - closes the open project.

- Save - saves changes in the project.

- Save as ... - creates the project copy in other file.

- Create - creates the new project.

- Delete - deletes the open project from the disk.

 

The Edit menu contains following commands:

- Add new section creates a new thematic section.

- Change - allows to change a section name.

- Delete - deletes selected section with all subsections and tables.

 

The Forms menu contains following submenus and commands:

- All forms - allows to control showing of all forms (to close, to open, to fold, to unfold).

- User forms - allows to control showing of all user forms (to close, to open, to fold, to unfold).

- Standard form - allows to control showing of the standard form (to close, to open, to fold, to unfold).

 

The Service menu contains following commands:

- Setting of ODBC allows to do access setting to the tables by using it ODBC drivers.

- SQL Manager - is the environment of development and administration of DBMS.

- Setting of BDE allows to do access setting to the tables by using resources of the Borland Database Engine system.

Data sources bookmark is intended to form a list of local tables and data modules with which it is supposed to interact at work with a map. Data module serves to provide the centralized access to components - data sets and their fields. At converting the information from projects of old format (*.dbp), the called queries automatically are placed to a tree of a data source.

There are following controlling buttons on the bookmark:

- Add button allows toadd the table of DB into project.

- Delete button allows to delete the table of DB from the project.

- Parameters button allows change a descriptive name in project for the selected table.

- Browse button allows to view the selected table.

- Create button allows to create a new DB table of dBASE or Paradox format.

- Structure button allows to change structure of the selected DB table.

- Map link button allows to do links setting of the table with map objects.

 

User forms bookmark is intended for creation and work with user's forms.

There are following controlling buttons on the bookmark:

- Add button calls out the form constructor..

- Change button opens selected form in the form constructor for editing.

- Delete button allows to delete selected user form from the project.

- Show button allows to open selected user form for operations.

- Map link button installs correlation between map objects types and user forms.  

 

The bookmark Data modules is intended for creation of data modules, which will be used for support of the centralized access to components - data sets and their fields.

There are following controlling buttons on the bookmark:

- Add  -     button calls out the form constructor and automatically adds the new data module.

- Change - button opens selected data module in the form constructor for editing.

- Delete -   button allows to delete selected data module from the project.

 

Standard form bookmark is intended for operations with the data from tables in tabular kind.

There are following controlling buttons on the bookmark:

- Add master button allows to select the master table of a DB for operations with a map (there can be any amount of master tables, but only one master table works with one map).

- Add detail button allows to select the table of a DB linked with the controlling table (not necessarily the main one) by any of fields, and to customize this link. The given mode allows to set relations one to many between two tables.

- Change link button allows to customize link between the tables by another field.

- Delete button allows to delete the selected table from the project.

- Browse button allows to view the selected table.

- Show button allows to open standard form for operations.

- Show - allows to open standard form for work.

 

Macroses bookmark is intended for rise of functionality at operation with the user's forms and allows to assign execution of definite operations to the form's buttons.

There are following controlling buttons on the bookmark:

- Add button allows to create and to add macros into the project.

- Change button allows to change the macros.

- Delete button allows to delete macros from the project.

 

Properties bookmark is intended for review and editing of project properties:

- Project name it is a conditional name which one was given by the user;

- File name it is the full filename of DB Project;

- Project map file name it is the full filename of a map for which one the DB Project is opened;

- Get data files path by project file this mode permits / forbids to store paths to datafiles (tables) concerning the project file. At the expense of it the carry of the project with its tables into other directory or onto other computer become easier.