How to add fields to an existing HAPI Database Fields module index.

SYMPTOMS

How to add fields to an existing HAPI Database Fields module index.

CAUSE

Not applicable.

RESOLUTION

Follow the steps below to add a field to the index and your SQL Server database:

• Open ZyINDEX | Define Fields and create your desired field (e.g. NEWFIELD).
• Open the following file C:\ZyLAB Data\Indexes\Indexname\Fields\fields.txt
• Set value PluginField=1
• Open DatabaseFields.xml (C:\ZyLAB Data\Indexes\indexname\ZxpPlugins\Database fields\) and add the field to the list:
  • <fielddefinition dbsync="0" id="NEWFIELD" name="NEWFIELD" type="2" default="0"></fielddefinition>
• Add the field in the database in the correct Instance/Table

APPLIES TO

6.0 Service Pack 1; 6.0 Service Pack 2; 6.0; 6.1; 6.1 Service Pack 1; 6.1 Service Pack 2; 6.2; 6.2 Service Pack 1; 6.2 Service Pack 2; 6.3