Is there a Query/View Designer tool

[Hitan]

Is there a tool/component that is similar to the
query/view designer in .net that can be used on a form so
that at runtime a user can develop their own queries
using this tool?

Cheers

 

[George Shubin]

I use Active Query by Korzh (http://www.korzh.com/activex/aq/). It's
Active-X but it still works with .Net. I'm not aware of anything equivalent
written in managed code. ComponentOne also has an Active-X query component:
http://www.componentone.com/products.aspx?ProductCode=1&ProductID=73 but I
don't think it is quite as nice as Active Query.

What attracted me to Active Query was that it shields the end user from
having to know SQL and all about relationships, etc. I set up the English
equivalents for table and field names, the table relationships, and the
valid logical comparisons for each field. The user does the rest. It quite
nice.

 

[Hitan]

Cheers for the info - i've decided to see if i can come
up with my own version which isn't going too badly at the
moment

Cheers

-----Original Message-----
I use Active Query by Korzh

(http://www.korzh.com/activex/aq/). It's

Active-X but it still works with .Net. I'm not aware of anything equivalent
written in managed code. ComponentOne also has an Active-X query component:
http://www.componentone.com/products.aspx?

ProductCode=1&ProductID=73 but I