Adding custom query building facility to app??

[ranasrule]

is there any way to add custom query building facility to an application ?? something like BinaryWORX BXQuery 3.0 ?? i urgently need help regarding this matter....thanks in advance

[jcis]

You could add Table names to a Combo, Fields names in another Combo. So when the user selected aTable you query that table Fields and then fill the other Combo with that field names.
Then it comes the WHERE part, you should allow the user to add as many conditions as he wants, using another Combo with: Bigger than, Slower than, Equals, Contains, starts with, ends with so the user can enter i.e:
UserName <Contains> "Jhon".
The another Combo to join conditions, it will contain i.e.: OR, AND
finally, ORDER BY another combo to show fields again.
When the user provided all the info, you can create your query with it.

[ranasrule]

You could add Table names to a Combo, Fields names in another Combo. So when the user selected aTable you query that table Fields and then fill the other Combo with that field names.
Then it comes the WHERE part, you should allow the user to add as many conditions as he wants, using another Combo with: Bigger than, Slower than, Equals, Contains, starts with, ends with so the user can enter i.e:
UserName <Contains> "Jhon".
The another Combo to join conditions, it will contain i.e.: OR, AND
finally, ORDER BY another combo to show fields again.
When the user provided all the info, you can create your query with it.

thanks for your help sir....really appreciate it....but is there any control available for free that will allow me to incorporate a visual query designer into my app ?

[Al42]

If there were one available it probably wouldn't be free. Someone in my company wrote a program that does what you want, but it took many man-months to get everything working properly.