StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>At least as of a few years ago, best query building component for Delphi was "Simple Query", an inexpensive component from a Russian toolmaker. Great component, features are much deeper and better thought out than they might at first appear. I used it with good success to integrate with data in QuantumGrid. (Since Simple Query merely generates an SQL string there isn't really much to integrate that way. But I did also tailor the visual appearance so it looked consistent with the QG.) <a href="http://devtools.korzh.com/query-builder-delphi/" rel="nofollow">http://devtools.korzh.com/query-builder-delphi/</a></p> <p>Note that the interface for Simple Query (and their "Easy Query" .NET component) is geared towards making it simple for users to generate valid searches without having any concept of tables, joins, or SQL. Takes a bit of foresight by developer to configure interface perfectly that way, but it's a nice feature. Also can be used as "full strength" solution for database experts.</p> <p>Also, I assume you're aware that QG has its own integrated visual query system. I think my main problem with that was that it was mostly geared towards filtering the existing dataset, but in any case Simple Query was far more flexible. </p> <p>Another thing, under the covers Simple Query has a number of objects that are used to generate the final SQL string, analogous to the code you posted and are asking about. Main purpose for this was just as intermediate stage between visual description and final output as SQL.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload