DF_FILE_SQL_FILTER_EQ

See Also: DF_FILE_SQL_FILTER, DF_FILE_SQL_FILTER_ACTIVE

 

When set to True, SQL Filters will be applied to all 'Find EQ' 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), revision 6 and higher

Type

Boolean, temporary

Access

Read / Write

Values

True, False

Syntax

Use cli.pkg

 

Get_Attribute DF_FILE_SQL_FILTER_EQ of {tableNumber} to {BooleanVariable}

Set_Attribute DF_FILE_SQL_FILTER_EQ of {tableNumber} to True / False

Sample

Use cli.pkg

 

Procedure FilterData

    Boolean bFilterEQ

    Handle hTable

 

    Move Customer.File_Number to hTable

 

    Get_Attribute DF_FILE_SQL_FILTER_EQ of hTable to bFilterEQ

End_Procedure

Remarks

This attribute allows the programmer to determine whether SQL filters are applied to 'Find EQ' operations. The default value is False.

Note that by default, global SQL filters are not applied to all find operations. The exceptions are Find EQ and FindByRowId. This exception exists to not break relates. The DF_FILE_SQL_FILTER_EQ attribute controls this behavior. So if you want your user to never see data that doesn’t match your filter (for example when building multi-tenant applications), then you need to make sure that DF_FILE_SQL_FILTER_EQ is set to true for each table.

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