I have recently purchased Active Query Builder and incorporated it into my application. I found the process very easy and straight forward and apart from a issues relatively pain free. All issues I had during the process were quickly resolved by the support guys.
I have used a couple of other query builder components and by far
Really great work!
The best DB-Designtool I could found after lot of deep testings.
My users are happy now about the ability to create complicate sql-selects visually AND keep the freedom to edit the sql-code manually too (True 2-way-designing).
I was so impressed with its capability to handle subqueries and unions, no other competitors offer that. Eventhough I have bought for a such component (the ELS query designer)... I have to buy again this component... and replace the previous one.
I had many situations where I required some easy tool for end-users to create queries and reports. Over the years I evaluated a few query building engines, all look nice, but none was useful or could be implemented with db in use. Finally I tried out Active Query Builder, and it does everything I need, two days after evaluating I bought full version, and a few days later my customers already had their dream, a excellent query builder integrated completly with their db and report engine. Now they can extract their data in a easy way.
Many thanks for making such a good product.
After an extensive search for a viable set of components for Delphi to integrate a general purpose query tool into my applications, I have at last found what I am looking for.
The ANSI 92 compatibility will also allow me to use this with embedded RDBMS solutions like Vista 2.
Marvellous...
With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.
Thanks to all the team involved. Please keep up the good work.
Free Major Upgrades
Price Protection
Royalty-free
Learn more...
Multiple joins
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Subqueries
Subqueries are located on separate tabs and can be accessed and built visually as easy as the main query.
Unions
Unions are managed from within the union panel at the corner of the visual query builder pane. You can build a query containing several unions in a few clicks!