PSC FilterBox can be used in your Delphi or C++ Builder application to visualize filter conditions or query WHERE clause elements. Users will be able to add, delete or change individual parts of the filter in an easy and understandable way. Users don't need to know anything about SQL in order to work with PSC FilterBox
 

FilterBox

Filter 

 

ShipDate = '11/30/99' and (((OrderNo >= 25) AND (OrderNo <= 32)) or ShipToContact = '58')

 
PSC FilterBox also includes much improved ListBox control (items can contain HTML formatting and clickable hotspots), Outlook like multi-month calendar control, calculator controls and some other highly useful components.
 

FilterBox

SQL 

Select * from orders
WHERE
PaymentMethod LIKE '%Credit%' and (Terms = 'FOB' or NOT (ShipVIA LIKE '%AmEx%')) and SaleDate <= '10/12/1999'

  
Please look on some of the product pictures and read what people say about components.
 
 
Do you know?
  
Automatic filter change
Just drop FilterBox (TPSCFltBox control) on the form, set  it's HookFIlterProp to True, connect it with desired Dataset (Dataset property) and run the application. Now, when you change conditions in FilterBox, linked Dataset's Filter property will change automatically. Wow!
 
Automatic SQL change
Set HookSQLProp to True and connect FilterBox with query. Now, when you change conditions at run-time, query's SQL property will be changed automatically and query will be reopened. Looks like magic.