Active Query Builder Free Edition

Active Query Builder Free Edition is a query building component for Borland Delphi and C++ Builder that provides you with all the necessary tools for working with queries. Designed to ease the development process, it enables you to generate complex queries.

The component is compatible with multiple development environments and comes with versions for .NET, ActiveX, Java and VCL. The free version only includes the ANSI-92 SQL parser and allows you to manage queries using an intuitive and simple interface.

The component can be used with both C++ Builder and Borland Delphi, providing you with a straightforward method for building simple SQL queries, queries containing unions and sub-queries.

Active Query Builder Free Edition is capable of automatically detecting the database server connection. Multiple database types are supported, including Microsoft SQL Server, Microsoft Access, MySQL, Oracle, PostgreSQL, Firebird, Interbase, DB2, Sybase, Informix, SQLite and more.

The demo application enables you to try out the component and view how it actually works. After selecting the desired SQL syntax, you can start building queries or sub-queries and represent them visually. The tables can be previewed and chained together and users can add new objects (tables, views, procedures, synonyms) to the database schema.

The application features a metadata loading wizard that you can use to update or replace the content of the Metadata Container, metadata filtering capabilities and a query statistics generator. You can customize the layout of the resulting SQL query text and set the component to suppress error messages. The appearance and the pane layout are fully customizable as well.

Active Query Builder Free Edition is a handy component that you can use to build, parse, analyze and execute simple or complex SQL queries. It provides an intuitive tool that can make the SQL query creation process much easier.