ABOUT

MK Query Builder III is a Delphi component you add in your application to offer your users a powerful Visual Query Builder. MKQB will allow for data mining, data exporting, and reporting without one line of code for you!

FEATURES

A user friendly interface

In fact it would be rather simple to open a text area in which the user could type a SQL request which would be to executed on the click of a button. It takes approximately 5 minutes to develop this functionality. But here is... the end-user does not know SQL and does not want to learn it. Moreover one imagines the possible disasters if any user could type SQL code sent to data bases! And even if all that were possible, it would remain to develop a universal export wizard and a report generator... Only that can be more expensive than the application. Fortunately, MKQB proposes a graphic visual interface representing the tables and their relationships. The user just has to click on the fields he wants to integrate into the answer. He poses in the same way filters, sorting, groups. All is simple. It is MKQB that will transform all that stuff into an acceptable SQL query sent to the server.

A user friendly interface

MKQB can be used in two manners: in expert mode or a user mode. Free with you to provide MKQB in the first mode but it is generally not what is practised. Indeed, in the expert mode it is possible to create data models and to see the real tables of the database. This work is generally reserved either to the originator of the software which will provide with MKQB the necessary models, or with a qualified administrator. The data models are invaluable assistances for the user: the tables which he sees are only those which are interesting for him, the relationships are not inevitably those of the database but those which simplify queries, the fields have fictitious names created by the administrator or the developer, the fields without interest or "sensitive" are completely hidden, etc. The models are at the base of MKQB power.

A user friendly interface

Thanks to the data models system the user reaches only the tables and the fields which he has the right to see. No moment he has to know the connection strings, the name of the servers, that of the tables, the fields. He sees only an idealized vision of the database. In the same way it does not have to input SQL code and only the SELECT is held by MKQB. Impossible to destroy the database by using MKQB. Impossible to access sensitive data nor to corrupt existing data.

PRICING

Pricing depends on user count or site licence and multi licencing.