Updatable property

Previous Next

This is where you specify whether the data in this column can be updated. If Updatable is set to No, a non-null value can never be changed once it is stored, and a NULL value will be treated as specified by 'Updatable Only If Null". If Updatable is set to Yes, the 'Updatable Only If Null' property will be ignored.

NOTE: If you use the Definer to specify that a particular column is not updatable or updatable only if Null, you cannot then use the Updatable property in the Windows Designer to change this setting for fields using that column. The Definer setting overrules the Windows Designer setting in this case. However, if you use the Definer to specify that a particular column IS updatable, you can then use the Windows Designer to specify that fields using this column are not updatable.

Note also that if you specify that a column or a field based on that column is not updatable, using the Definer or the Windows Designer, it is not possible to change the background color of affected fields.