I have written a *lot* of code to generate sql queries on the
fly. I've got another extension to my application that requires
re-writting a lot of similar code. I'm looking for some other
solution.
Having plowed throught the VBxtras catalogue, I've come across
a couple of tools that claim to produce SQL code on the fly.
I need something that will allow me to provide my users with a
SQL builder operating on something like a drag-and-drop model.
It has to be simple and intuitive. (The current situation gives
them list boxes, with select and sort check boxes underneath for
each of the selectable fields.)
Does anyone have any experience with any such tool?