Active Query Builder » SQL Query Builder

Active Query Builder ActiveX Edition

COM object/ActiveX control for Visual SQL Query Building

Active Query Builder ActiveX Edition is a visual query builder control that allows your end-users to build complex SQL queries via an intuitive visual interface. Active Query Builder ActiveX Edition is a true two-way query builder, so that you can combine the visual query building with direct SQL query text editing.

Have a look at the Demo web page built with Active Query Builder ActiveX Edition. Demo works with the Internet Explorer only.

Product summary

Latest version:: 1.36.2
History of changes
Price from:: $295
All purchase options

Download free trial

Active Query Builder ActiveX Edition requirements

Supports Visual Studio, Visual Studio .NET, PowerBuilder, Delphi and many other IDEs.
Can be used in VBA applications, such as MS Excel and MS Access.
Works in any ActiveX-compatible environment: Win32, .NET applications, Internet Explorer.
Available for x32 and x64 environments.

Main Features of Active Query Builder ActiveX Edition

Simple and clear visual SQL query building interface
- Easy building of complex SQL queries with unions and sub-queries.
- MS-Access style user-friendly interface with drag & drop support.
- Two-way SQL query building (combined with SQL text editing).
- Customisable SQL query text formatting.
Learn more about the user interface »
Customisable query building environment
- Complete substitution of unintelligible object and field names for user-friendly aliases.
- Representing high-usage expressions and sub-queries as ordinary database objects and fields.
Learn more about customising the environment »
Easy metadata management
- Selective unwanted objects hiding, automatic filtration by schema or object name.
- Loading metadata programmatically from different sources (via web services or from datasets).
- Working disconnected from the database, storing metadata in XML files.
Learn more about metadata management »
Powerful API to analyse and modify SQL queries
- Restricting access to unwanted objects, preventing SQL query execution.
- Quick access to comprehensive information about the query: database objects and fields, query columns and parameters.
- Easy changing of SQL queries to transfigure result data according to the end-user requests.
Learn more about programming API »
The full feature list of Active Query Builder ActiveX Edition.
Active Query Builder ActiveX Edition - Live Demo.

Related pages

News

12/14/2023 Active Query Builder ASP.NET Edition 3.10 adds support for SignalR client-server communication
Support for SignalR lets use Active Query Builder in Blazor apps.
09/20/2023 Active Query Builder VCL Edition 1.34 adds support for Snowflake and Firebird 4
New SQL Text editor API improvements and performance optimizations are made.
04/11/2023 Active Query Builder VCL Edition 1.33 speeds up the SQL text editor
The new SQL filter builder control lets save user-defined filters between work sessions.
RSS

» Active Query Builder news
Subscribe

Tweets

Tweets by @activedbsoft

Follow @activedbsoft

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!