Active Query Builder ActiveX Edition Icon

Active Query Builder ActiveX Edition

True two-way Query Builder ActiveX control to build complex SQL queries easily.

Active Query Builder ActiveX EditionOverview

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.

New:
+ German translation is updated.
+ French translation is updated.
- MS SQL Server: Special Chars in parameter names (_,@,...) are accepted now.
- Interbase: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP are supported now.
+ Derived table alias is shown in the query structure tree instead of entire
SQL text.

NEW

Fixed some bugs.

Active Query Builder ActiveX EditionInformation

Version
1.15.12
Date
10.10.10
License
Free
Language
English
File Size
4.82MB
Developer
Category
SubCategory
Operating Systems
Windows XP, 2000, 98
System Requirements
No additional system requirements.

Active Query Builder ActiveX EditionPrevious Versions

Active Query Builder ASP.NET Edition Icon
A fully featured, two-way visually based ASP.NET query builder.
Trial
Active Query Builder Free Edition Icon
Free SQL query builder component - best solution for beginners and professionals
Free
More
TVicHW32 Icon
TVicHW32 is a general purpose device driver.
Demo
DFM Editor Icon
Standalone editor for Delphi Form files (*.dfm) in both binary and text format
Free
InstrumentLab VCL Icon
VCL/FMX Visual instruments - Gauges, Thermometers, Clocks, Segment Indicators
Trial
Delphi Icon
Delphi is Windows and multi-platform development software.
Trial
DynamicSkinForm Icon
Create cool application with skins support!
Trial
CAD Import VCL: dwg, dxf, plt, svg, cgm in Delphi Icon
DXF DWG PLT HPGL SVG CGM Import for Borland Delphi and C++Builder developers
Trial
ComPort Icon
Delphi/BCB component for serial communication for Windows 95/98/ME/NT/2000/XP.
Trial
EMS Source Rescuer Icon
Application which can help you to restore your lost Delphi project sources.
Trial
More