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 tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

See Also

  • RowID Field section in “Defining Tables” chapter.

FeedbackOpens in a new tab