_field and a unique record identifier - Forum - OpenEdge General - Progress Community

_field and a unique record identifier


_field and a unique record identifier

  • Hi there. I would like to store unique unchanging values for database fields in my table. But I cannot find a unique value to store from the _field meta-schema table. I cannot use _field-name since it may change. So I was thinking of using the ROWID of a _field record but does ROWID values change on a dump and reload like RECID does? Maybe not because I see _file-recid field in the _field table?

  • Using the recid is not a good idea either. It may change during dump and load.

    That's not a problem for the meta schema as the records aren't actually dumped and loaded (DDL).