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.
Latest Changes for Active Query Builder ActiveX Edition:
- 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 improvement
Software related to Active Query Builder ActiveX Edition
Active Query Builder Free Edition Active Query builder is a component suite which gives your end-users the ability to create complex SQL queries via an intuitive visual interface. Active Query Builder can be used in almost any software and it is absolutely free!
Active Query Builder Delphi VCL Edition Active Query Builder is a Delphi VCL component to create SQL queries easily. True two-way query builder with user-friendly interface and unique query research capabilities; a perfect choice for both SQL beginners and experienced query writers.
FastQueryBuilder FastQueryBuilder (FQB) is a visual query builder. You can use FQB in your applications written in Borland Delphi or Borland C++Builder environment for simple SQL generator creation.
Modem Master ActiveX Component Powerful COM Port wrapper Active-X. Can be used with Visual Basic, Delphi, MS Visual C++, Java Script, and any other applications capable to host AxtiveX components.
EasyQuery.NET (WinForms) 1.6.1 EasyQuery.NET WinForms edition is a set native of .NET classes, components and controls that provides an ability to include end-user-oriented query builder into your Windows Forms application and allows your users to describe their requests in native language instead of SQL, build their own queries and get all data they want without any assistance from the developer and without necessity to understand your database design or table relationships.
Visual SQL-Designer Light Visual SQL-Designer Light is a program for easy visual constructing hard SQL-query for any database and write it. Support MSSQL 6.5-7.0-2000, MSAccess and other ODBC databases. Union query builder.Stored Procedure wizard.
Sound Converter ActiveX Component Sound Converter ActiveX is a powerful component for converting of sound formats. Support any file format including MP3, DSP, GSM, ADPCM, PCM ant many others. Can be used with Visual Basic, Delphi, MS Visual C++, Java.
Superior SQL Builder Visually build complete SQL scripts - other query tools only build single SQL queries. Introduces massive time savings. Easy to use. Build complex SQL scripts without typing any SQL. Supports Oracle, SQL Server, MySQL, Access.
XL-DBQuery XL-DBQuery is a powerful add-in for Microsoft Excel that makes it easy to perform data analysis and reporting.
SkWHOIS ActiveX Control A powerful, intelligent, flexible, and lightweight WHOIS ActiveX control. It allows developers to integrate the WHOIS/NICNAME protocol message sending capability into their applications.
SocketTools Scripting Edition 4.5 SocketTools Scripting Edition consists of Component Object Model (COM) libraries designed primarily for use in scripting languages such as VBScript JavaScript and PHP. The Scripting Edition components do not have the inherent overhead of ActiveX controls and they implement a threading model that makes them much more efficient to use with Active Server Pages (ASP) and similar environments.
