SupportsSQLFilters - DataDictionary

Can be queried to determine if this table is capable of supporting SQL filtering and the Data Dictionary SQL filter interface

Type: Function
Return Data Type: Boolean

Syntax

Function SupportsSQLFilters Returns Boolean

Call Example

Get SupportsSQLFilters to BooleanVariable

Description

This can be called to determine if this table is capable of supporting SQL filtering and the DataDictionary (DD) SQL filter interface. This is determined by the driver. If the driver does not support SQL filtering, you should leave pbUseDDSQLFilters set to False and not use SQL filtering.

Note that pbUseDDSQLFilters is not tied to SupportsSQLFilters and that pbUseDDSQLFilters is not automatically set to True when SupportsSQLFilters is True. If you start using SQL filters, your record finding strategies may change significantly and you may not want to use the same strategies with a database such as the embedded database. This change should be a deliberate developer decision.