Active Query Builder - VCL - V1.10.5 - 概要
by Active Database Software - 製品のタイプ: コンポーネント / VCL
結果
Active Query Builder VCL Edition by Active Database Software
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.
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.
What's new in Active Query Builder V1.10.5
Support of Embarcadero Delphi 2009 IDE is added.
Ability to compile the component with DevExpress controls is added.
What's new in Active Query Builder V1.10
Customization of datasource's field lists at the query building area has been made
The FieldsListOptions property allows you to customize drawing of the datasource's field lists. You may show/hide/customize the following columns:
Status picture: is used now to mark Primary key fields only (FieldsListOptions.MarkColumnOptions)
Field Name (FieldsListOptions.NameColumnOptions)
Field Type (FieldsListOptions.TypeColumnOptions)
Field Description: (FieldsListOptions.DescriptionColumnOptions)
Field lists are retrieved now through database server specific queries. This allows to display field types for specific database servers correctly, also this may speed up retrieval of the field lists
Basic support of Mimer SQL dialect is added
MySQL and Firebird parameters parsing is improved
Other minor improvements and bug fixes are made
What's new in Active Query Builder V1.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
Unicode support is implemented in the Columns pane and in all of the Properties windows. (The rest of the visual controls were already Unicode compatible before)
Appliance of the ObjectPrefixSkipping property to the drop-down list of database objects in the Columns Pane is made
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?
Ability to convert queries between dialects is implemented
Spanish localization is added
The component has became digitally signed, so now there will be no problems with automatic installation from Internet and displaying on client machines using Windows XP SP2 and/or Internet Explorer 7
PartNumbers: PC-516519-176843 516519-176843 PC-516519-176844 516519-176844 PC-516519-176845 516519-176845 PC-516519-176846 516519-176846 PC-516519-176847 516519-176847 PC-516519-176848 516519-176848
Publisher PartNumbers: 1651482 1655420 1655421 1655422 1732496 1732500
PurchaseOptions: Active Query Builder Standard VCL Edition V1.10.5 1 Developer License , Active Query Builder Standard VCL Edition V1.10.5 4 Developer Team License , Active Query Builder Standard VCL Edition V1.10.5 8 Developer Team License , Active Query Builder Standard VCL Edition V1.10.5 with Source Code 1 Developer License , Active Query Builder Standard VCL Edition V1.10.5 with Source Code 4 Developer Team License , Active Query Builder Standard VCL Edition V1.10.5 with Source Code 8 Developer Team License
Resources: Read the Active Query Builder Quick Start Guide (includes sample Source), Read the Active Query Builder Help, Read the Active Query Builder License Agreement, Download the Active Query Builder Demo, Download the Active Query Builder VCL Free Edition on to your computer - Limited Functionality
Operating System for Deployment: Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95
Architecture of Product: 32Bit
Product Type: Component
Component Type: VCL
Compatible Containers: Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, C++Builder 6, Delphi 2009, Delphi 2005 (9.0), Delphi 7.0, Delphi 6.0, Delphi 5.0, Oracle Database 9i, Oracle Database 10g
Keywords: SQL query language Author sql query builder visual delphi
