property SQLFilter: string ;
Description
Use SQLFilter property to set dataset filter as SQL condition. When filtering is active, SQLFilter specifies the condition which determines the records which are visible for the application. Setting SQLFilter automatically resets Filter property and vice-versa.
Condition that you specify as SQLFilter should be syntactically valid for the SQL database working behind Mediator. It will be used as a part of SQL WHERE condition.
Example:
products.SQLFilter := 'ProdClass='+QuotedStr('F'); // set SQL filter condition
products.Filtered := true; // activate filtering