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.
See Also: