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.
Table
The DataFlex SQL Drivers (SQL Server, DB2 and ODBC), revision 6 and higher
Boolean, temporary
Read / Write
True, False
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
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
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).