Active Query Builder ActiveX Edition is a visual SQL query builder component designed for software developers to integrate into database-driven applications. It functions as a true two-way query builder, meaning users can seamlessly switch between dragging-and-dropping visual elements and directly editing the SQL raw text. Core Capabilities
Visual Interface: Offers an MS-Access-style drag-and-drop interface where users can build complex queries, define groupings/sorting, and construct criteria without manual coding.
Sub-query & Union Support: Features dedicated working areas for each sub-query or union, making advanced data retrieval easier to manage visually.
SQL Parser & Formatter: Uses a powerful SQL parser that reverse-engineers raw SQL text back into a visual representation and standardizes code layouts.
Query Analysis & Security: Allows developers to inspect queries, tracking the exact tables and fields used. This helps prevent unauthorized database commands before execution. Environmental Compatibility
Supported Environments: Built as a COM object/ActiveX control. It integrates with Visual Studio, PowerBuilder, VBA environments (like MS Excel and MS Access), and other ActiveX-enabled IDEs.
Architecture: Compatible with both x32 and x64 Windows systems.
Supported Dialects: Natively parses SQL structures for Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MS Access, Informix, Sybase, and Firebird. Licensing Options
Standard Subscription: Includes the compiled ActiveX Edition control with one year of support and upgrades, but lacks underlying source code.
Standard Subscription with Source Code: Bundles both the ActiveX Edition and VCL Edition alongside the complete underlying source code.
Fully functional trial evaluations can be acquired on the Active Query Builder Downloads Page.
If you are evaluating this for a specific project, let me know your development environment (e.g., VB6, MS Access VBA, .NET) and database server so I can provide more targeted integration details. SQL Query Builder ActiveX control/COM component
Leave a Reply