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).