LockForeignKeys

The LockForeignKeys Rules Engine property can be used to override the Lock_Foreign_Keys deployment parameter setting for the current deployment context and for the duration of the current session.

You can set deployment parameters in USoft Authorizer for 3 different deployment contexts: Client/Server, RunBatch, and Rules Service. See the Authorizer Guide. One way to access the Authorizer Guide is to press CTRL + F1 in USoft Authorizer.

This setting determines whether or not the parent record must be locked when foreign keys are checked. If LockForeignKeys = Yes (the default), the parent record is locked whilst changes are made to child records.

You can also make this setting separately for an individual relationship by setting that relationship's "Lock Foreign Key on Check" attribute.

Setting this property

You can reset this property by executing:

SELECT RulesEngine.SetProperty( 'LockForeignKeys', 'value' )

value ::= { Yes | No }

This entire statement is case-insensitive, including the property name and the values of value.

Getting this property

You can get the current value of this property by executing:

SELECT RulesEngine.GetProperty( 'LockForeignKeys' )

This entire statement is case-insensitive, including the property name.