Skip to content

DF_FILE_SQL_FILTER_EQ

See Also

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 avoid breaking relates. The DF_FILE_SQL_FILTER_EQ attribute controls this behavior. 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 ensure that DF_FILE_SQL_FILTER_EQ is set to True for each table.

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