Active Query Builder ActiveX Edition 1.9    

Author Active Database Software Website Active Database Software - Active Query Builder ActiveX Edition homepage Licence Commercial Price $295.00 OS Win95, Win98, WinME, WinNT 4.x, WinXP, Windows2000, Windows2003 Date Released April 02, 2008 Downloads 324 Filesize 3.38 MB Language English, ChineseSimplified, Czech, Italian, Spanish Install Support Install and Uninstall Requirements N/A Keywords Your Rating   - click to rate - you will be first!

[ View full size screenshot ]

Download Active Query Builder ActiveX Edition   Buy Full Version   Add to Watch List

Active Query Builder is a .Net-ready ActiveX visual query builder component to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful and user-friendly GUI that allows you to build queries involving unions and sub-queries. Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query editing. The interface of Active Query Builder is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder such as the ability to build queries with unions and sub-queries make it the best solution for professional developers. Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation. Active Query Builder can be used in any software project which supports ActiveX controls as well as in the .Net projects. For example, you can use it with Visual Basic 6.0, Visual Basic .NET, Visual C++ 6.0, Visual C#, PowerBuilder, Delphi and so on. Active Query Builder was successfully tested in Windows.Forms and ASP.NET environments, with .NET Framework 1.1 and 2.0. In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.

Download Active Query Builder ActiveX Edition   Buy Full Version   Add to Watch List

Active Query Builder ActiveX Edition - Latest User Reviews

 Write a Review   

Active Query Builder ActiveX Edition - The Latest Versions History

Version	Date Released	Status	Release Notes
Active Query Builder ActiveX Edition 1.9	Apr 2, 2008	Major Update	- Full Unicode support. - Firebird syntax: common table expressions are supported now. - The new Universal Syntax Provider is added to the Free version for better compatibility with specific database servers.
Active Query Builder ActiveX Edition 1.8	Nov 8, 2007	Major Update	+ 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.
Active Query Builder ActiveX Edition 1.7.9	Mar 27, 2007	Minor Update	- 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.
Active Query Builder ActiveX Edition 1.7.7	Jan 8, 2007	New Release	- 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.
Active Query Builder ActiveX Edition 1.7.5	Dec 4, 2006	New Release	* Retrieval of extended information about user parameters in the query: data type, related table and field names. * New property to get access to output columns of the query. * Better handling of the asterisk item in SELECT list. * Multiple fixes and improvements for MS Access SQL dialect.
Active Query Builder ActiveX Edition 1.7	Oct 24, 2006	New Release	- Database Objects Tree is implemented. - Ability to localize the component is added. - Some visual improvements are made. - A number of bugs are fixed.
Active Query Builder ActiveX Edition 1.6	Aug 7, 2006	New Release	Working in offline mode. Now Active Query Builder supports working in offline mode, loading metadata information from a previously saved XML file. This is very convenient if the component is used to work with a remote database, for example in the ASP.NET environment.
Active Query Builder ActiveX Edition 1.5.5	Jul 3, 2006	New Release	* Active SQL Parser has full Unicode support now. * 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.
Active Query Builder ActiveX Edition 1.5	May 22, 2006	New Release	* 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. * Now you may specify whether you want to display the standard error message. * Most memory leaks have been eliminated. * Other minor bugfixes and improvements.