Active Query Builder ActiveX Edition 1.13

Free Active Query Builder ActiveX Edition screenshot file5 stars award!
Active Query Builder ActiveX Edition is a control to build complex SQL queries via an intuitive visual interface similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, to construct criteria in a simple and direct way. Each union and sub-query has its own working area where it could be built visually as easy as single query.

Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query editing. The sophisticated Active SQL parser can translate any valid SQL statement into it`s visual representation. SQL Formatter will allow you to customize the SQL code layout the way you like it. Ability to retrieve various information about the query, such as list of used tables and fields, allows you to prevent execution of unauthorized queries.

Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects.

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.

The latest version of our component allows you to replace real table and field names with the user-friendly aliases.

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 and .NET, Visual C++ 6.0, Visual C#, PowerBuilder and so on. Active Query Builder was successfully tested in Windows.Forms and ASP.NET environments, with .NET Framework 1.1 and higher.
Type : Commercial ($295.00) » EULA
OS Support : Windows All
Date stamp / Size : Nov, 27. 2006 / 3666 kBytes
Asked : N/A
Users' value : - Write a Review
Download Active Query Builder ActiveX Edition fileOrder Active Query Builder ActiveX EditionImage of Active Query Builder ActiveX Edition
Update history of Active Query Builder ActiveX Edition
v1.13 (August, 4. 2009)
- Firebird 2.5 support is added.
- Other minor improvements and bugfixes.
v1.9 (April, 12. 2008)
- 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.
v1.8 (November, 12. 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.
v1.7.9 (May, 23. 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.
Distribution permissions for Active Query Builder ActiveX Edition
This product can be freely distributed through the Internet. To publish it on a CD, please contact sales@activequerybuilder.com
Featured Vista Files

VoIP SIP Client SDK - A powerful and highly versatile VoIP SDK. Our SIP SDK provides a powerful and highly versatile solution to add quickly SIP (Session Initiation Protocol) based dial and receive phone calls features in your software applications.

Generates virtual printer driver to extract text from printable documents, then save it to file or upload to a server. You can customize it with interactive wizard and embed into your application

Visual Basic RS232 serial communications library. Control multiple ports simultaneously. Includes line status/control, modem control,ASCII/XMODEM/YMODEM, virtual ports (USB to serial,Bluetooth serial, hardware/software flow control.Win64,Win32,Win16

X360 Video Capture ActiveX Control helps application developers and programmers create applications with video capture capabilities from any video source devices (such as Digital Video(DV), web cameras or TV tuners, etc.) installed in the system.

IP2Location IP-COUNTRY-REGION-CITY-LATITUD E-LONGITUDE-ISP is commericial lookup database that translates IP address to country, region, city, ISP, latitude and longitude. Developers use IP2Location for projects related to web and client applications