Active Query Builder - .NET - V1.6.5

von Active Database Software - Produkttyp: Komponente / .NET WinForms / .NET Class / 100% Managed Code

Bitte beachten Sie, diese Produktinformation ist nicht in deutscher Sprache verfügbar.
Build complex SQL queries via an intuitive visual interface. Active Query Builder .NET Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder .NET Edition supports Visual Studio 2005, Windows.Forms environment (100% Managed Code, No direct Win32 interop calls).

Unsere regulären Preise werden nachstehend angezeigt. Bitte melden Sie sich an um Ihre ermäßigten Preise zu sehen.

Active Query Builder Standard .NET Windows Forms Edition V1.6.5 - without Source Code

In den Einkaufswagen	$ 441.00	1 Developer License	Download (1.8 MB)
In den Einkaufswagen	$ 882.00	4 Developer Team License	Download (1.8 MB)
In den Einkaufswagen	$ 1,411.20	8 Developer Team License	Download (1.8 MB)

Active Query Builder Standard .NET Windows Forms Edition V1.6.5 - with Source Code

In den Einkaufswagen	$ 1,166.20	1 Developer License with Source Code	Download (2.2 MB)
In den Einkaufswagen	$ 1,558.20	4 Developer Team License with Source Code	Download (2.2 MB)
In den Einkaufswagen	$ 2,048.20	8 Developer Team License with Source Code	Download (2.2 MB)

Active Query Builder Standard .NET Windows Forms Edition V1.6.5 - Source Code License

In den Einkaufswagen $ 931.00 1 Source Code License (Requires that you already own a developer license) Prüfen Download (2.2 MB)

Unsere Preise beinhalten einen technischen Support durch ComponentSource und für die meisten herunterladbaren Produkte zusätzlich ein Online-Backup sowie eine kostenlose Aktualisierung auf die neue Version, sofern sie binnen 30 Tagen nach dem Kauf freigegeben werden. Die angezeigten Preise sind zuzüglich aller Steuern. Für mehr Information zu eventuell anfallende Steuern, gehen Sie bitte auf diese Webseite. Alle Verkäufe unterliegen unseren Standardgeschäftsbedingungen und unseren Rückgaberegeln. Treten Sie bitte mit uns in Kontakt , wenn Sie eine Lizenzierungsoption anfordern möchten, die in der obigen Liste nicht aufgeführt ist, einschließlich Mehrplatzlizenzen und ältere Versionen.

Unsere regulären Preise werden oben angezeigt. Bitte melden Sie sich an um Ihre ermäßigten Preise zu sehen.

What's new in V1.6

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 full-featured MDI Demo application with source code is added to the Trial and Standard versions
Tne new demo project is added to illustrate ability to modify queries programmatically (QueryModificationDemo)
The new source code sample is added to demonstrate non-standard ways of metadata loading (LoadMetadataDemo)
The new HideSingleDatabaseNode property is added to the QueryBuilder.MetadataTreeOptions to hide unnecessary database node if all objects are loaded from single database
Query properties dialog for PostgreSQL syntax is implemented

What's New in V1.5

Ability to define alternate names for database objects and their fields is implemented
Non-visual mode is added
New UniversalSyntaxProvider 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
New UniversalMetadataProvider is added - This metadata provider may operate with any valid Connection object, no matter what ADO.NET data provider you use
Firebird syntax: common table expressions are supported now
Memory and speed optimizations are made
Polish translation is added

What's New in V1.3.5

MySQL, PostgreSQL, Firebird, Sybase, IBM DB2 and Informix SQL dialects are supported now
Now it is possible to detect SQL syntax of the database server automatically using the AutoSyntaxProvider
Ability to perform basic conversion of SQL queries between dialects is implemented
Ability to retrieve metadata from VistaDB and Advantage Database Server is added
Improved usability of building GROUP BY/HAVING clauses with the new criteria list grouping style
Significantly increased speed of working
Ability to localize the component is implemented
Ability to customize or hide context menus using the ValidateContextMenu event is added

Common product information about Active Query Builder

Completely visual building of complex SQL queries.
MS-Access style and SQL Server style interface.
User-friendly interface with drag & drop support.
Powerful means of working with parameters.
Working in offline mode, storing metadata in XML files.
Delicate handling of user queries.
Sophisticated SQL parser.
SQL Server, Access, Oracle, MySQL and ANSI SQL/92 dialects support.
VistaDB desktop database support.
SQL Formatter.

Integration with C#, VB.NET and other VS2005 built applications is achieved by setting a few properties or adding a few lines of code.
The component may be integrated into your .NET 2.0 application with just a few lines of code. Unlike many other .NET query building solutions, Active Query Builder for .NET 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.

Full access to internal query representation objects.
Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

ADO.NET and generic event driven driver.
We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we created the generic event-driven metadata provider. You can use it to provide metadata information from any data source. It's quite simple and has just a few events to implement. Using the generic event-driven metadata provider you can work disconnected providing all necessary metadata information by yourself. (Generic event-driven metadata provider will be available on release)

List of features of Active Query Builder .NET Edition.

Completely visual building of complex SQL queries

Visual building of sub-queries
Visual building of unions
Columns pane allowing to define grouping, sorting, and constructing criteria
Tree pane to browse and navigate query tree
Database objects tree pane to add objects to query
Forecast: Visual criteria constructing tool for Where and Having clauses - Not available in free edition

Powerful programming interface

Configuring the layout of generated SQL code
Retrieving the list of parameters found in the query - Not available in free edition
Retrieving extended information about parameters: datatype, related object, field and operator - Not available in free edition
Ability to work with metadata - Not available in free edition
Ability to build queries with objects from different databases - Not available in free edition
Pre-filtering of database objects to speed up metadata loading - Not available in free edition
Saving and loading all metadata information to XML format - Not available in free edition
Ability to work in offline mode - Not available in free edition
Full access to internal query representation objects - Not available in free edition

Support for various SQL Dialects