Is it possible to edit a key field on the records tab of a data type?
I needed to edit records udsing the "Record" tab of the data type (in either Dev or App studio), however, one of the fields I need to edit is defined as "key, read only". Thus the options are to delete the record and recreate it or to export the entire table, edit in Excel and import it back. Is there a way to change the field to editable within the data type? On the data model tab, settings are greyed out for key fields.
Accepted Solution
Updated: 28 Jul 2023 17:27 EDT
Bits in Glass
IN
@JMark515 you are right, if the physical database table has records, keys cannot be modified. You will need to change the key the table and then edit. Please refer below link. Else what I would suggest is, you can keep pyguid as primary key, so that all the field can be editable.
NCS Pte. Ltd
SG
Hi @JMark515: Could you please help us to understand why you need to change the value of a key column? Once a column / property is defined as key, it should be unique. If you change the value of the class key property for a specific row, system will consider it as new row and technically it will try to insert a new row in the DB. Hence the key column for existing rows are as read only.
Thanks.