Skip to main content

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.SQLOpens in a new window 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.

FeedbackOpens in a new window