Allow end-users to build complex SQL queries via an intuitive interface

New metadata provider for the DBISAM embedded database engine is added (www.elevatesoft.com)New metadata provider for the SQLDirect BDE replacement component library is added (www.sqldirect-soft.com)New metadata provider for the Core Lab SQL Server DAC is added (www.crlab.com/sdac).TacQueryBuilder: The new Clear method is added to empty currently builded SQL query at a timeTacQueryBuilder.AddObjectFormOptions: New properties are added to hide tabs of the Add Object Window (TablesVisible, ViewsVisible, ProceduresVisible)TacQueryBuilder: The new ColumnWidthExpression property is added to define initial width of columns in the Columns paneOther minor bugfixes and improvements

Changes

• New metadata provider for the DBISAM embedded database engine is added (www.elevatesoft.com)New metadata provider for the SQLDirect BDE replacement component library is added (www.sqldirect-soft.com)New metadata provider for the Core Lab SQL Server DAC is added (www.crlab.com/sdac).TacQueryBuilder: The new Clear method is added to empty currently builded SQL query at a timeTacQueryBuilder.AddObjectFormOptions: New properties are added to hide tabs of the Add Object Window (TablesVisible, ViewsVisible, ProceduresVisible)TacQueryBuilder: The new ColumnWidthExpression property is added to define initial width of columns in the Columns paneOther minor bugfixes and improvements

The unique features of Active SQL Query Builder such as the ability to build queries with unions and subqueries make it the best solution for professional developers. Each union and sub-query has its own working area where it could be built visually as easy a single query. The interface of Active SQL Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. Active SQL Query Builder allows you to tune all parameters of each single part of a query with the dialog window.

Working with Active SQL Query builder you can access each union and subquery in one-touch; complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way. Active SQL Query Builder supports all MySQL extensions, such as the Limit clause that limits the number of rows, the SELECT INTO OUTFILE/DUMPFILE forms, query options, locking definitions, subqueries for MySQL server version starting from 4.1.