Good DB Filter Dialog

Hi Experts,

I'm currently working on a project in which the users need to be able to filter some records.  For this I'm looking for a good DB Filter dialog component which allows the user to select the fields, condition and parameters on which he wants to filter.  If possible the component should also be able to give an SQL WHERE Clause instead of a filter too.

Any component will do.  Preferably freeware with source, but if it is a good one which is shareware or commercial it will be OK to.  If I don't find a good working one, I'll need to write my own, so any input is welcome.

Thanks a lot in advance,


Stefaan
LVL 3
StefaanAsked:
Who is Participating?
 
fulg0reCommented:
www.dream-com.com
FilterBox it is called. shareware but fare cheap and with fullsourcecode...
0
 
BlackDeathCommented:
hi, stefaan!

has this got *any*thing 2 do with hs2000?


;-)

BlackDeath.
0
 
StefaanAuthor Commented:
Hi,

No, it hasn't ;-) It's for a project I'm working on in my Company.  Nothing to do with HS2000, though it could be usefull there too.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
BlackDeathCommented:
cul8r, termin8r!

BlackDeath.
0
 
NetoManCommented:
We made a delphi 4 form (not a compo, maybe later...) that show all the records that user will be able to filter to. (receive this records as a parameter on a list). With its records properties, the apropiate control appears (combos, edits) and generates a Kind of Query By Example (QBE-SQL) sentences that define the Query that will show the data. It works very cool for us.
 
As you say, if you don´t find any good compo, maybe I can help you with the construction of your own or giving you the code.

NetoMan :)
0
 
StefaanAuthor Commented:
Hi,

Well, the component from www.dream-com.com works great, but if you are willing to send me your could you can do it at Stefaan_Lesage@peopleware.be

If it is good, I'll try to make a component of it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.