This applies to filtering predicates. It controls how failed predicates are treated. A predicate fails if:

An invalid data value, either in the query or record data, is encountered.

An empty date value, either in the query or record data, is encountered and the Fail Empty Predicate flag is true.

A conversion is requested on data that can't be converted to the requested type.

Other rare conditions may cause a failure.

If this flag is true a failed predicate is treated as a false value, i.e. the record is not returned. If this value is false a failed predicate is treated as true, i.e. the test is considered to have passed even if other clauses in the test returned false.

For example:

	Copy Code
( $"count" < 10 ) and ( DATE $"issue-date" > DATE "10/10/2010" )

If the value of "issue-date" is "notadate", causing the conversion to fail, and the Fail Invalid Predicate flag is set to false, the test returns true even if "count" is greater then 10.

This flag should be set to false only after careful consideration of the above.

The default value is true.