Active Query Builder - VCL - V1.9.1

Présentation | Prix et licences | Évaluations et téléchargements | Compatibilité | Infos éditeur | Revues | Forums | Récapitulatif

Veuillez noter que les informations sur les produits ne sont pas disponibles en français.
Build complex SQL queries via an intuitive visual interface. Active Query Builder is a query builder component suite for Borland Delphi and C++Builder which gives your end-users the ability to create complex SQL queries containing unions and sub-queries via an intuitive visual interface. Active Query Builder has complete support of Oracle, Microsoft SQL Server, MySQL, PostgreSQL, InterBase, Informix and more SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.

Nos prix standard sont montrés ci-dessous. Veuillez vous connecter pour voir vos prix.

Active Query Builder Standard VCL Edition V1.9.1

Active Query Builder Standard VCL Edition V1.9.1 with Source Code

Nos prix comprennent le support technique ComponentSource et, pour la majorité des produits téléchargeables, une sauvegarde en ligne ainsi qu'une mise à niveau GRATUITE si la nouvelle version est parue pendant les 30 jours consécutifs à votre achat.  Toutes les ventes sont sujettes à nos Termes et Conditions standard à notre Politique de renvoi. Veuillez nous contacter si vous avez besoin d'une option de licence (licence de volume et versions précédentes) qui ne figure pas sur la liste ci-dessus.

Nos prix standard sont montrés ci-dessus. Veuillez vous connecter pour voir vos prix.

What's new in the Active Query Builder version 1.9.1

Common changes for ActiveX and VCL

• Sleep mode is implemented - This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing
• New properties are added to parenthesize conditions in WHERE clause
• The new boolean QueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode property is added to hide the database node from metadata objects tree when there is only one database is loaded to the metadata container
• The new demo is added to illustrate ability to replace real object and field names with user-friendly alternate names (Demos/AlternateNames)
• PostgreSQL query properties form is added
• Numerous fixes in MySQL, DB2, Sybase and other SQL dialects
• Chinese, Italian, German and Portuguese (Brazil) localizations files are updated. Spanish, Czech, Turkish and Japanese localization require updating.

What's new in Active Query Builder V1.9.0.8

• The new Universal Syntax Provider is added to the Free version - It is based on the ANSI SQL/92 syntax but allows to determine most of popular database servers, thus it successfully retrieves metadata and applies specific settings for them, to let the user build simple queries for these servers
• Firebird syntax: common table expressions are supported now

What's new in Active Query Builder V1.8.5

Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made

• Added possibility to compile the component on the base of TNT Unicode visual library. (This option is available for the Standard version with Source Code only as it requires re-compilation with the third party source code)
• AnyDAC and NativeDB connectivity packages are added
• The new OnAfterCreateControl and OnBeforeDestroyControl events were added to the TacQueryBuilder class to configure internal properties of the query builder controls
• The new OnLoadTableMetadata, OnLoadViewMetadata, OnLoadProcedureMetadata, OnLoadSynonymMetadata events are added to the TacEventMetadataProvider class. Use them to load the fields list for appropriate objects using the TacMetadataObject reference
• Firebird syntax: common table expressions are supported now (Standard Edition only)
• DB2 Syntax: Fixed problems with metadata retrieval for specific server versions (Standard Edition only)

What's new in Active Query Builder V1.7.9

• 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

What's new in Active Query Builder 1.7.7?

• Added support for C++ Builder 5 IDE and BDS 2006 C++ Builder personality
• Ability to convert queries between dialects is implemented
• Spanish localization is added

Overview

Active Query Builder inclides an SQL parser that correctly handles SQL queries containing multiple nested joins and other detailed points of SQL syntax. Another feature is the graphical engine that allows you to build queries involving unions, nested joins and sub-queries.

The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface.

Active Query Builder supports Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, SQLite, and ANSI-92 SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source.

The component may be integrated into a Delphi or C++ Builder application with just a few lines of code. Active Query Builder does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible. The product is shipped with a detailed help system and a demo application to help you quickly master the product.

Note: Active Query Builder Standard VCL Edition with Source Code is also included in ActiveX Edition with Source Code.