I just stumbled upon the field _Mod-sequence in the meta table _Index. Does anybody know what it is used for? The Progress Knowledge Base does not show any hits.
The usual value is ? but sometimes it contains 10 digit integers in our installation. Since I added some of the affected indices myself using a .df file I do not know where the values come from. I cannot write to this field either.
Here is a code example to show the values (only a few indices of our application show up).
The usual value is ? but sometimes it contains 10 digit integers in our installation. Since I added some of the affected indices myself using a .df file I do not know where the values come from. I cannot write to this field either.
Here is a code example to show the values (only a few indices of our application show up).
Code:
FOR EACH _index
WHERE _index._Mod-sequence <> ?
NO-LOCK,
FIRST _file
WHERE RECID(_file) = _index._File-recid
NO-LOCK:
DISPLAY
_file._file-name
_index._Index-name
STRING(_index._Mod-sequence, '9999999999':U).
END.