| True DataControl 8.0 Reference > RangeCondition Object > RangeCondition Object Properties > SkipIfEmpty Property |
SkipIfEmpty Property
If True, the range condition is skipped when any of the variables occurring in the ValueExpression is empty.
RangeCondition.SkipIfEmpty= boolean
Read/Write at run time and design time. Property applies to RangeCondition object.
This property specifies how to handle the range condition when a variable contained within the ValueExpression is empty.
If set to True (the default), the range condition is skipped; it will not restrict the resulting recordset. Sometimes the range condition should not be skipped if there are undefined variables in it, but rather produce an empty recordset. In these cases, you must set this property to False. However, the default setting (True) is useful for ad-hoc query forms where the user is not required to specify values for all fields.
If this property is set to False, the range condition is imposed even if it contains variables with empty values. In this case, the outcome of the range condition depends on the result of ValueExpression evaluation. For example, it can use IsEmpty and IsNull functions to test for empty values.
See Field Range Conditions for more information.
See Also