Active Query Builder Delphi VCL Edition History

Version history for Active Query Builder Delphi VCL Edition shows you how often it was updated over the past months (starting Aug 08, 2005) as well as 'what is new' information for each update (if available, since this information provided by the author).

Version: 1.13
Size: 9789 KB
OS: Win 95/98/ME/NT/2000/XP
Description:   Active Query Builder is a Delphi VCL component to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.

v 1.9 updated on Apr 11, 2008

- Compilation of the component with TNT and TMS Unicode visual library. - Firebird syntax: common table expressions are supported now. - AnyDAC, ODBC Express and NativeDB connectivity packages are added. - The new Universal Syntax Provider is added to the Free version.

v 1.8 updated on Nov 16, 2007

+ Improved usability of building GROUP BY/HAVING clauses. + Ability to define alternate names for database objects and fields. + Support of IBM DB2 and ANSI SQL/2003 standard dialects. + Six new languages were added.

v 1.7.9 updated on Apr 26, 2007

- Chinese, Czech and Italian localizations are added. - Support of Synonyms and Analytic Functions in Oracle, Join Object Hints, Ranking and Aggregate Window Functions in MS SQL Server, more precise erroneous token reporting, other SQL parsing improvements. - Many other bugfixes and improvements.

v 1.6 updated on Aug 21, 2006

Working in offline mode. Now Active Query Builder supports working in offline mode, loading metadata information from a previously saved XML file. Storing and loading metadata information from an XML file makes loading metadata almost instant.

v 1.5.5 updated on Jul 10, 2006

* Active SQL Parser has full Unicode support now. * New metadata provider for the NexusDB database is added ( * Ability to retrieve information about objects and columns being used in the query is implemented. * The new IdentCaseSens property is added to control the behavior of the ANSI syntax providers. This property determines whether an identifier should be quoted or not. * Other minor bugfixes and improvements.

v 1.5 updated on May 30, 2006

* Ability to to work with metadata is implemented. * Ability to build queries with objects from different databases is implemented. * Pre-filtering of database objects is implemented to speed up metadata loading process. * We have created the User’s guide for end-users of Active Query Builder. * Most memory leaks have been eliminated. * Other minor bugfixes and improvements.

v 1.4 updated on Mar 06, 2006

- New metadata provider for the DBISAM embedded database engine is added ( - New metadata provider for the SQLDirect BDE replacement component library is added ( - New metadata provider for the Core Lab SQL Server DAC is added ( - TacQueryBuilder: The new Clear method is added to empty currently builded SQL query at a time. - TacQueryBuilder.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 pane. - Other minor bugfixes and improvements.

v 1.3.5 updated on Jan 11, 2006

- Delphi 2006 is supported now. - Informix SQL dialect is supported now. - ANSI SQL/89 dialect is supported now. - New metadata provider for the Luxena Informix Data Access Components is added ( - New metadata providers for the MicroOLAP Data Access Components for MySQL and PostgreSQL are added ( - Correct handling of case sensitive identifiers is implemented. - The interface of the OnGetFields event is changed. This change allows you to pass WideString field names as well as to store case sensitive field names. - TacQueryBuilder, TacSQLBuilderPlainText: The new QuoteAllIdentifiers property is added. Setting them to True you'll get all identifiers in the query quoted. - Many bugfixes in Oracle, Firebird and InterBase SQL dialects. - Minor interface improvements.

v 1.2 updated on Nov 28, 2005

Unknown changes

v 1.0 updated on Oct 03, 2005

- Interbase (Firebird) dialect supported (TacIBSyntaxProvider). - Significant improvements in the parsing engine. Amount of memory used for parsing of large queries was decreased dramatically. - New metadata provider for Interbase Express added (TacQBIBExMetadataProvider). - New metadata provider for dbExpress added (TacQBdbExMetadataProvider).

v 0.9.9 updated on Sep 19, 2005

- New ability is added to work with stored procedures and functions in TacBaseSyntaxProvider. - TacQueryBuilder: New methods are added to retrieve lists of tables, views and procedures to support server specific rules of retrieval. For example, to retrieve a list of tables for MS SQL Server, 'exec sp_tables' is executed now. - New OnGetProcedureNames event is added to the TacEventMetadataProvider component. - Many improvements and bugfixes in the TacBaseSQLBuilder component - TacQueryBuilder: The new LinkPainterClass public property is added to change link painting style programmatically.

v 0.9.8 updated on Sep 05, 2005

- We have released detailed help system! - Query Tree Pane implemented. Now you can see the whole query structure at one sight! - TacBaseSQLBuilder has been upgraded dramatically: Many new options implemented to format SQL query text as you wish. - TacQueryBuilder. The new VisibleColumnsPane property added. It allows you to show/hide query builder columns pane. - We have implemented a new way of object names quotation. Now quotation is applied only when building SQL query text. - TacQueryBuilder. The new SyncSQL property added. It allows you to provide immediate update of internal query builder objects as well as SQL query text generated by attached SQL builder components. - TacOnSQLError. New parameters are added to locate erroneous token of SQL statement more precisely. - TacDatasourceObject. The ObjectName property has been renamed to DatabaseObject. - The acAbout unit has been renamed to acQBAbout to avoid conflicts with AppControls components. - A lot of minor improvements and bugfixes.

v 0.9.7 updated on Aug 22, 2005

- PostgreSQL dialect supported. - New Generic Event-driven Metadata Provider added. - Significant improvements in all SQL syntax providers. - TacSelectList: AddExpression and InsertExpression methods implemented to add any arbitrary expression to the select list. - TacQueryBuilder.AddObjectFormOptions: New properties added: Constraints, Height and Width. - Classes named Tast*MetadataProvider were removed, TacBaseMetadataProvider class was moved to acAST.pas module. - Fixed bug with unavailability of forms for editing tables and relationships for ANSI-92 SQL dialect. - In some cases while working with parenthetic unions, sending of notification messages was hanged. Fixed now. - A lot of minor improvements and bugfixes.

v 0.9.5 updated on Aug 08, 2005

- New metadata provider for Zeos Database Objects: TacQBZeosMetadataProvider - New metadata provider for Borland Database Engine: TacQBBDEMetadataProvider - TacQueryBuilder: Added complex property AddObjectFormOptions that allows you to setup Add Object Dialog Form easily. - TacBaseMetadataProvider: Method GetObjectNames replaced with two new methods: GetTableNames and GetViewNames. - Now all the database object names comparisons are performed in syntax providers.

Go back to the Active Query Builder Delphi VCL Edition review

More Downloads

  • Visual Query Tool - Pro

    Database maintenance based on parameterized SQL queries and processing automation.

  • DIHtmlParser - Source Code

    DIHtmlParser is a lightening fast and flexible Html Parser for Borland Delphi 4/5/6/7 to extract information from Html documents.

  • Visual LogParser

    Visual LogParser is a free Visual tool for the Microsoft LogParser engine. It enable user to query any log files or data source with a SQL syntax.

  • IBSurgeon Viewer

    IBSurgeon Viewer is a free tool for investigation of internal InterBase/Firebird database structure. It will help you to understand the low-level work of database engine, provide details about InterBase architecture and on-disk structure.

  • SaVcl

    SaVcl - VCL for direct access to Sybase Anywhere. FreeWare. Sources.