Description
Use TPSCFltBld to perform advanced Filter and SQL modifications. You can connect TPSCFltBld to the TPSCFltBox.FilterSource property if you want to use TPSCFltBox for editing of the Filter/SQL conditions at run-time. You can also connect TPSCFltBld to the TPSCFltDlg component.
After you dropped TPSCFltBld component on your form, specify source of the field names. You can do it using DataSet property or Fields property.
After you specified source of the field names you can use Items property to edit filter conditions. At design time you can also right click on the component and edit Items with handy dialog (select 'Edit component' menu item).
You can use FilterStr property to get filter string depending on the specified filter conditions. Use SQL property to get SQL text which can be assigned directly to the SQL property of the TQuery alike components. When filter conditions in the component are changed, OnChange event is fired.
To change filter condition templates use Templates and FilterOptions properties. To specify additional parameters for the fields use FieldParams property.
