Applies To:
  • CitectSCADA 1.x, 2.x, 3.x, 4.x, 5.0

If a database device is opened that has an index configured but the index file does not exist, then the index file is created. To configure a database device index, completed the Header field in the Device form. Use the DevOpen CiCode function to open a database device. 

CIT has confirmed this to be a problem in Citect for Windows versions to 3.4/4.2 and 5.0. This problem is fixed in Citect for Windows versions 5.01.

To reindex an indexed database device, delete the index file (database file name with an extension .NDX). Open the database and an updated index file is created.

The reindexing operation is only required if the index and the database file are not synchronised. This can occur if the index configuration is removed, the database is modified and the index is subsequently reconfigured. Cicode database device functions update the index for indexed database devices.

If the index definition is removed, then the index file is not removed. Similarly if the index is defined and the index file already exists, then no index is created. In this case if the existing index file is out of date, then the results of index operations are undefined.

See Knowledge Base article Q2149 for information on using indexed database devices.