UniqueKeyCheck

The UniqueKeyCheck Rules Engine property can be used to override the Unique_Key_Check 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 Rules Engine must perform unique key check in the case of non-manual data entry, for example, when a call to the SqlScript() action is executed.

Setting this property

You can reset this property by executing:

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

value ::= { Yes | No }

This entire statement is case-insensitive, including the property name and the values of value. 'Yes' is the USoft factory default, meaning that the Unique_Key_Check deployment parameter is set to 'True' by default.

Getting this property

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

SELECT RulesEngine.GetProperty( 'UniqueKeyCheck' )

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