Applies To:
  • CitectSCADA 1.00, 2.00, 3.00, 4.00, 5.00
Summary:
Citect uses database files (dBASE III format, DBF) for storing some of it's system data. An example of this is the HELP.DBF. Occasionally you may need to modify these files for specific reasons. However, before modifying them, are there any other requirements ??

For example: I have made a new driver using the Driver Development Kit (DDK). I wish to modify the HELP.DBF to add a new record for the drop down lists on the communications forms. When I add the new record however, the new entry still does not appear on the drop-down lists. Why?

Solution:
Some of the database (DBF) files have an associated index file (NDX). The NDX file does not get automatically updated if you modify the DBF file. This must be done manually. There are a few methods of doing this, including:
  1. Use dBASE to re-index the DBF files OR 
  2. Create a Citect project and use some cicode to do this operation OR
  3. Use the Index.exe command line utility.

Refer to the dBASE instruction manual if you intend using the dBASE option.

The method using the cicode is as follows:

  1. Create a new Citect project.
  2. Configure a Device for the respective DBF you want re-indexed.
  3. Create a cicode function to re-index the device.
  4. Compile and Run the project and the function the re-index the device.
    Note: with no IO Devices defined, the compiler will generate a warning. This can be ignored.

The INDEX.EXE command line utility can be obtained from Citect Support, but is an independent product and is not supported by Ci Technologies. To use the utility on the HELP.DBF file, run the following command from the Citect Bin directory:

    INDEX HELP TYPE

 
Keywords:
 

Attachments