Does anybody know, if there is any kind of Query Builder or SQL Builder
that i can use in my programs, so that the users can build their own queries
I know there are some that you can purchase. Take a look at
I was on a tight budget, so I used a technique of combining text boxes and
drop down boxes to let users build a query. They chose the fields and the
operators out of list boxes and typed in the criteria to the text boxes. I
used a DbGrid blow the query to show the returned data. I can't say it was
the best solution (there was a lot of coding involved) but it did work.
Hope this helps...
Is anyone aware of any add-on apps that can be included in distributed apps
compiled with the compact compiler that will allow users of a product to
dynamically build and save their own reports and/or queries. I realize that
this can't be done with Fox's current implementation of SQL; but a slick
programmer could write code to do it with SET FILTER/SET RELATION statements.
I have been on M/S's case for a long time (and FOX's before they were bought
by M/S) to provide this feature.