_field and a unique record identifier

Posted by ericg on 29-Jun-2009 14:21

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?

All Replies

Posted by Admin on 29-Jun-2009 16:13

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).

This thread is closed