Description

Active Query Builder is a visual SQL query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface.

• Completely visual building of complex SQL queries: Each union and sub-query has its own working area where it could be built visually as easy a single query.

• MS Access style visual query building UI: The interface is similar to either MS Access query construction interface, but is much more powerful compared to other similar components.

• User-friendly interface with drag & drop support. Complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way.

• Powerful means of working with parameters: Active Query Builder can get various information about parsed query like lists of tables and fields used in the query. You can learn parameter names and data types, and discover to what database objects and fields they related to.

• Working in offline mode: In case direct connection to the database is not possible, save database schema to XML file in advance, then load metadata from this file.

• Limiting access to unwanted objects: Deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. You can also check your queries on the presence of unwanted objects before their execution.

• User-friendly query building environment: Active Query Builder allows for substitution of the user-friendly aliases for unintelligible names of your DB tables and fields. Though, your end-users can still build SQL scripts by hand: all the aliases used in query text will be automatically replaced with the real names in the result query text.

• Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite, Teradata, Netezza and ANSI SQL/92, 89 and 2003 dialects SQL syntax. Using Active Query Builder you can determine the currently used database server automatically.

• SQL Formatter: Using the Active SQL Query Builder you can customize SQL code the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.

• Localization: It is possible to localize Active Query Builder completely and to switch between available languages in run-time. Dozens of localizations are ready to use.

The Professional version additionally includes the Advanced SQL Text Editor with code completion and syntax highlighting.

Active Query Builder - is all that you need to work with SQL queries.

Informations

• Status: Partially restricted
• Source: On purchase/registration
• price: $195
• Source price: $395
• Size: 79 135kB

Platforms: C10, C10.1, C10.2, C2k10, C2k6, C2k7, C2k9, CB5, CB6, CB64, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, D10, D10.1, D10.2, D2005, D2006, D2007, D2009, D2010, D5, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE64, DXE7, DXE8

Description

Advanced Query Builder is a powerful component suite for Borland Delphi and C++ Builder intended for visual building SQL statements for the SELECT, INSERT, UPDATE and DELETE clauses. It allows you to build new queries visually and/or graphically represent the existing queries in your own applications. The suite includes components for working with standard SQL, MS SQL, InterBase/FireBird, MySQL, PostgreSQL and many more dialects. Advanced Query Builder enables users to make up large and complicated SQL queries with unions and subqueries for different servers without any knowledge of the SQL syntax.

Key Features:

• Standard SQL, InterBase/Firebird, MySQL, PostgreSQL, Oracle, DB2 and DBISAM support;
• Detailed help system and a demo application for a quicker mastering of the product;
• Powerful component and property editors, which allow to set easily many query building parameters at the design-time;
• Creation of queries with unions and subqueries;
• High productivity even on slow computers;
• Powerful SQL parser, which allows you to represent complicate SQL statements visually;
• Possibility of creating TxxxQueryBuilder components easily for working with the chosen server;
• Full customization of font colors, object appearance, etc.

Informations

• Status: With Nag-Screen
• Source: On purchase/registration
• price: $195
• Size: 16 157kB

Platforms: C10, C2k10, C2k6, C2k7, C2k9, CB5, CB6, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, D10, D2005, D2006, D2007, D2009, D2010, D5, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE7, DXE8

Description

FastQueryBuilder is an easy to use visual SQL query builder. It works with local and client-server databases.

You can integrate FastQueryBuilder into your applications written in Embarcadero Delphi, C++Builder and RAD Studio (VCL as well as FMX - FireMonkey) or Lazarus.

FastQueryBuilder enables you to work with local and client-server databases by means of the BDE. It also allows you to work with other data-access components such as ADO, IBX and FIBPlus.

Supports Embarcadero (ex Borland and ex CodeGear) Delphi, C++Builder 4, 5, 6, 7 and RAD Studio 2005/2006/2007/2009 and Lazarus

Displays a visual model of the query for use and editing

Possible to embed Visual Query Designer into any window in your application

Allows FastQueryBuilder designer to be integrated into any application window

Offers full visual customization of query parameters

It is so simple to query a DB: open FastQueryBuilder -> make a query -> see the result.

Informations

• Status: Partially restricted
• Source: On purchase/registration
• price: $69
• Size: 913kB

Platforms: CB4, CB5, CB6, C2k6, D2006, D4, D5, D6, D7, D2005

Description

FilterBox can be used in your Delphi application to visualize filter conditions or query WHERE clause elements. Users will be able to add, delete or change individual parts of the filter in an easy and understandable way. Users don't need to know anything about SQL in order to work with FilterBox.

Informations

• Status: Fully functional
• Source: Included
• Size: 1 493kB

Platforms: DXE8

Description

With this component you're able to add a visual query builder to your application. Full database platfrom independent, table names and fields are retrived via TableList property and OnGetTableFields event. Supports only SQL Select command.

The component is based on the QBuilder 4.0a by Sergey Orlik.

Informations

• Status: Fully functional
• Source: Included
• Exe demo: included
• Size: 270kB

Platforms: D5, D6

Description

Allows you easily build Queries for Interbase databases.

Informations

• Status: Fully functional
• Source: Included
• Size: 14kB

Platforms: D5

Description

MK Query Builder III is a component you add in your application to offer your users a powerful Visual Query Builder.

MKQB will allow for data mining, data exporting, and reporting without one line of code for you.

Informations

• Status: Demo only
• Source: On purchase/registration
• price: $720
• Exe demo: included
• Size: 1 202kB

Platforms: D2006, D3, D4, D5, D6, D7

Description

QBuilder is a very simple visual query builder. It doesn't check your links and columns properties when generate SQL code, but you can edit this code before running and you have all source code. It is created as a Delphi native VCL dialog component. Now supports BDE, IBObjects and FreeIBComponents to work with InterBase database server.

Informations

• Status: Fully functional
• Source: Included
• Size: 571kB

Platforms: CB4, D4

Description

The component provides a convenient interface for end users to create SQL SELECT statements from ADO databases using drag and drop techniques.

The constructed SQL statement is returned in WIDESTRING and TSTRINGS format.

Informations

• Status: Fully functional
• Source: Included
• Size: 53kB

Platforms: D5

Description

This component library allows you to integrate end-user-oriented query builder into your Delphi or C++Builder project.

Users do not need to understand your database design or table relationships. They do not see real tables and real field names and see only the table names and field descriptions you want them to see. Operators can be spelled out (e.g. "is equal to" instead of mathematical symbols), field values can be replaced with descriptions (e.g. "MasterCard" instead of actual values like "MC") that makes interface more friendly. Users describe requests by creating their native language sentences and receive the results.

Easy Query builds SQL SELECT statement according to user's demand and database structure you define. It can build SELECT statements with sub-queries, with table aliases, with all kind of joins. If you need a powerful Query Builder in your application - Easy Query is your choice. If you need a filter component with user friendly interface and ability to build sophisticated filters - use Easy Query for it. If you use ADO, ODBC Express, DBISAM, etc. instead of BDE - it is not a problem because we have a lot of BDE Alternatives support components and technology to create a new BDE Alternative support component in several minutes. If your users don't know English - it is not a problem - all interface elements are easy translatable into other languages.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $129
• Source price: $199
• Size: 18 213kB

Platforms: C2k10, C2k6, C2k7, C2k9, CB6, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, D2005, D2006, D2007, D2009, D2010, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE7, DXE8

Description

This control will execute both QBE and SQL queries.

Informations

• Status: Fully functional
• Source: Included
• Size: 7kB

Platforms: D1, D2

Description

Query Studio provides an easy way to give users access to powerful queries without requiring any knowledge about SQL. Users can setup complex queries in an almost natural language way with Query Studio. Dropping the component VisualQuery on the form and connect to the database opens the visual query power of Query Studio.

Feature details:

• Visual definition of SQL, in a natural language-like way
• Localization support to easily translate all user interface elements
• Allows definition of source tables and joins
• Allows definition of order and filtering
• Exclusive parameter editors feature: a value in the filter condition can be attached to a parameter editor. End-user can change editor value and it will automatically be reflected in SQL
• Supports SQL syntax for Microsoft Access, Microsoft SQL Server, AnyDAC, Oracle, MySQL, Nexus, Interbase, DBISAM and Local BDE
• Automatically set TDataset properties. Supports BDE, ADO, AnyDAC, IBX, DBISAM, Nexus, IBO, DirectSQL and DBExpress dataset descendants
• Automatic grouping feature for aggregate functions usage
• Support custom field expressions and custom filter conditions.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $85
• Size: 3 345kB

Platforms: C2k7, D2007, C2k9, D2009, C2k10, D2010, D7, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8

Description

Away to standtartizes your application by having one form from witch you can select one or more records from any table. It's main use is to provide way to let user chose from LookUp tables.

No need to write form for it - form included. Just put the component of any DataModule (or form), point to Database and write SQL statement. Then use Execute method and get the result in RxLib MemoryData Table.

RxLib required.

Informations

• Status: Fully functional
• Source: Included
• Size: 49kB

Platforms: D4, D5

Description

Component for visual creation of SQL-queries. Enables the user to create SQL-queries by simply putting together English sentences with the mouse. The following languages are also supported: Norwegian, Spanish, French and German.

The main new feature of TQuickSelect is the ability to access queries (reports) without having to execute the dialog. A new component (with full source) is included as an example. If you want to take a look on a full overview of new features, visit the TQuickSelect homepage.

Informations

• Status: Fully functional
• Source: On purchase/registration
• Source price: $45
• Size: 154kB

Platforms: D2, D3, D4, D5

Description

Visual Query Builder component to generate and even run multi-database SQL queries. Works equally well with server based SQL and Borland's local SQL. Built-in Query wizard answers your user's requests for adhoc queries with as little as one line of code. Registered users also receive a developers sql property editor version for their own use, help files and full source code. The foundation component and code need by all Delphi database developers. Delphi Choice 96 Award Winner.

Informations

• Status: Trial (work while IDE is running)
• Source: N/A
• price: $55
• Size: 141kB

Platforms: D2, D3, D4, D5, D6, D1

Description

This component allows you to build quries in your applications. It is very similar to MS Access Visual Query Builder. Now support two DBEngines: IBX and BDE. Number of Engines will be Extended in future versions.

Informations

• Status: Fully functional
• Source: Included
• Size: 203kB

Platforms: D6, D7