Issue

A custom index is added through the Data Dictionary. However, the Update From Data Dictionary function does not add the index to the Microsoft SQL Server (SQL) table.

Solution or Workaround

Beginning in Sage Pro ERP 7.2, a new option was added to the Index File Maintenance screen to allow for the creation of indexes in SQL. The Create index for SQL option must be selected to create the index in SQL when performing the Update From Data Dictionary function. Please refer to the attached document for an example of this (SQL Index.jpg).

Note: All indexes that exist within the Data Dictionary, in the out-of-box product, will not have this option selected. This is by design in case the index is specific to the Microsoft Visual FoxPro (VFP) version of Sage Pro. If using Sage Pro 7.1 or Sage Pro 7.0 with SQL, this option does not exist. However, the Sqlcreat field in the SYDINDX table can be manually edited to insert a value of “1,” for the custom index record. A value of “0” indicates that this is for VFP only. This will then create the index in Microsoft SQL while performing the Update From Data Dictionary function.

© Copyright Sage Software