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') |
|
FilterBox |
SQL |
|
Select * from orders |
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. |