ApplySQLFilterStr - DataDictionary
Called before a Data Dictionary find / read to set DD SQL Filters
Type: Procedure
Parameters
| Parameter | Type | Description |
|---|---|---|
| sFilter | String | The assembled SQL filter string |
Syntax
Procedure ApplySQLFilterStr String sFilter
Call Example
Send ApplySQLFilterStr sFilter
Description
Applies the passed SQL filter. If empty, it ensures that no filter is applied. If non-empty, it sets the filter as active, sets the filter string and ensures this is applied to all finds (including find EQ).
This is called before a Data Dictionary find / read is performed to update the SQL Filter with the assembled SQL filter based on psSQLFilter and pbApplyGlobalSQLFilters.
This message is the last chance to manipulate the generated SQL string. See Data_Set_PreFind and ApplySQLFilter for more details.