Tech Tip: Index is invalid or missing when saving a record
PRODUCT: 4D | VERSION: 13.5 | PLATFORM: Mac & Win
Published On: August 1, 2014
Starting with version 13.5, all fields that are unique must be indexed. If a table has a unique field that is not indexed, when adding and saving a new record, the following error message is displayed:

When updating and saving an existing record, the following error is displayed:

In order to add or update records after version 13.5, be sure to add an index on all fields with the unique attribute checked.

When updating and saving an existing record, the following error is displayed:

In order to add or update records after version 13.5, be sure to add an index on all fields with the unique attribute checked.

See Also: