Skip to content

DF_FILE_SQL_FILTER_ACTIVE

See Also: DF_FILE_SQL_FILTER_EQ

Indicates whether the SQL filter is applied on find operations. This is a global table filter. See pbApplyGlobalSQLFilters for more information.

Level

Table

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC)

Type

Boolean, temporary

Access

Read / Write

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_FILE_SQL_FILTER_ACTIVE of {tableNumber} to {BooleanVariable}
Set_Attribute DF_FILE_SQL_FILTER_ACTIVE of {tableNumber} to {True|False}

Remarks

This attribute controls if the filter in DF_FILE_SQL_FILTER is applied or not. When set to true, the filter is applied; when set to false, the filter is not applied.

For more information about SQL filters, see Using SQL Filters (Constraints).