Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Good DB Filter Dialog

Posted on 2000-04-19
6
Medium Priority
?
358 Views
Last Modified: 2012-05-04
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
0
Comment
Question by:Stefaan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 1

Accepted Solution

by:
fulg0re earned 150 total points
ID: 2730021
www.dream-com.com
FilterBox it is called. shareware but fare cheap and with fullsourcecode...
0
 
LVL 1

Expert Comment

by:BlackDeath
ID: 2731056
hi, stefaan!

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


;-)

BlackDeath.
0
 
LVL 3

Author Comment

by:Stefaan
ID: 2731137
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Expert Comment

by:BlackDeath
ID: 2731159
cul8r, termin8r!

BlackDeath.
0
 
LVL 2

Expert Comment

by:NetoMan
ID: 2731627
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
 
LVL 3

Author Comment

by:Stefaan
ID: 2733592
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question