Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page The ddi.exe utility for editing database templates and external settings files  Editing the external setting file (intellect.ddi) using the ddi.exe utility Next page


To edit the template of the main database, open it using the File -> Open menu. The template files are stored in the root of the Intellect program folder.

Note.

To open the recently used file, select the Last files item in the File menu or open the context menu in the Names tab.

Note.

The Paste from file item in the File menu allows opening several files by adding tables, described in other dbi files, to the open dbi file.

Intellect.dbi file contains the list of main tables and fields of the database. User-defined tables and fields are stored in a separate file – intellect.ext.dbi. This file is made separate from the main file, to eliminate the need to re-insert user-defined tables and fields into the main file, in case of Intellect system update. The contents of these files are merged upon Intellect start-up.

To view the database template, open the DBI tab in the top left corner of the window. The list of the tables of the main Intellect database will be displayed in the left panel. The right panel will show the list of fields of the selected database.

To delete, add, edit or copy object fields, use the table on the left of the utility box.

The following parameters of the table fields are displayed:

  1. Field name – the name of the field in the database.
  2. Type – data type of the field contents. Available types:
    1. BIT – checkboxes taking logical values Yes and No;
    2. CHAR – fields with a few symbols;
    3. DATETIME – date and time in the following format: date – dd-mm-yyyy, time – hh:mm:ss;
    4. DOUBLE, INTEGER, SMALLINT – numerical fields of corresponding types;
    5. TEXT – fields with the text.
  3. Size – maximum number of units of the specified format in a field.
  4. Description – field name shown in the interface.

The database is to be refreshed after the changes were made.

  • No labels