Skip to main content
Next section

AllowRowIDUpdate

Allow user to update RowID values.

Synopsis

[SQL]    AllowRowIDUpdate=n

n is either 1 or 0. The default value is 0.

Description

When AllowRowIDUpdate is enabled (n = 1), RowID values are user-modifiable. Modifying RowID values can have serious consequences and should only be done in very specific cases and with extreme caution. Set to 1 only if you are doing your own filing in a BEFORE trigger and using the %SkipFiling flag. Otherwise, use the default of 0.

Changing This Parameter

You can change AllowRowIDUpdate with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).

See Also

  • RowID Field section in “Defining Tables” chapter in Using InterSystems SQL.