Sql Queries and Active Query Builder Activex Edition Software for Windows

MSISQL (ISQL for Microsoft SQL)
$39.95 - microOLAP Technologies LTD

Interactive SQL for MSSQL is a handy tool for working with Microsoft SQL tables, views and queries. Rich feature set allows you to browse and modify MSSQL table data, create SQL queries within a useful editor (with syntax highlight and code completion features) or build them in the Visual Query Builder.

Interactive SQL for MSSQL provides various features for optimizing your work with SQL, such as:

* SQL History for logging all executed queries with grouping by database connections;
* Templates manager for creating and editing custom SQL queries templates. Each template can be called by predefined keyboard shortcut;
* Data export into 14 available formats, including MS Excel, MS Access, HTML, XML, etc.
* Full customization of program appearance, editor behavior, etc.
* Connection profiles manager;
* Embedded Visual Query Builder;
* SQL scripts may be loaded/saved from/to external file;
* MDI interface for executing SQL queries in separate windows;
* Localized interface;

---

---

EMS SQL Query 2007 for MySQL
$95 - EMS Database Management Solutions, Inc

EMS SQL Query for MySQL is an utility that lets you quickly and simply build SQL queries to MySQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and many more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.

Key Features:

- User-friendly graphical interface
- Latest MySQL versions support: compatibility with all MySQL versions from 3.23 to 6.x
- Support of UTF8 data
- Asynchronous query execution
- Connect through SSH tunnel: establish connection to an intermediate SSH server and forward all MySQL commands through the secure tunnel
- Connect through HTTP tunnel in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to MySQL
- Using drag-and-drop operations when selecting tables and fields for a query visually
- Working simultaneously with several queries in separate windows
- Registering selected databases to work with
- Multiple database connections
- Navigation within recently used queries and selecting the required queries
- Syntax highlight, "quick code" and keyboard templates for faster editing query text
- Tools for data grouping and filtering
- The ability to create queries with unions and subqueries visually
- The ability to create diagrams based on queries
- Capabilities for viewing query plans
- Powerful BLOB viewer/editor with several types of viewing BLOB data
- Flexible personalization of graphical user interface
- Multi-language GUI support

---

---

EMS SQL Query 2007 for PostgreSQL
$95 - EMS Database Management Solutions, Inc

EMS SQL Query for PostgreSQL is an utility that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and many more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.

Key Features:

- User-friendly graphical interface
- Full support of PostgreSQL server up to version 8.2.x
- Support of UTF8 data
- Connect through SSH tunnel: establish connection to an intermediate SSH server and forward all PostgreSQL commands through the secure tunnel
- Connect through HTTP tunnel in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to PostgreSQL
- Using drag-and-drop operations when selecting tables and fields for a query visually
- Working simultaneously with several queries in separate windows
- Registering databases for working with the required databases only
- Multiple database connections
- Navigation within recently used queries and selecting the required queries
- Syntax highlight, "quick code" and keyboard templates for faster editing query text
- Tools for data grouping and filtering
- The ability to create queries with unions and subqueries visually
- The ability to create diagrams based on queries
- Capabilities for viewing query plans
- Powerful BLOB viewer/editor with several types of viewing BLOB data
- Flexible personalization of graphical user interface
- Multi-language GUI support

---

EMS SQL Query 2007 for DB2
$95 - EMS Database Management Solutions, Inc

EMS SQL Query for DB2 is a utility that lets you quickly and simply build SQL queries to IBM DB2 databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and many more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.

Key Features:

- User-friendly graphical interface
- Asynchronous query execution
-Using drag-and-drop operations when selecting tables and fields for a query visually
- Working simultaneously with several queries in separate windows
- Navigation within recently used queries and selecting the required queries
- Syntax highlight, "quick code" and keyboard templates for faster editing query text
- Tools for data grouping and filtering
- The ability to create queries with unions and subqueries visually
- The ability to create diagrams based on queries
- Capabilities for viewing query plans
- Powerful BLOB viewer/editor with several types of viewing BLOB data
- Flexible personalization of graphical user interface
- Multi-language GUI support

---

Active Query Builder Delphi VCL Edition
$195 - Active Database Software

Active Query Builder is a true two-way visual query builder component for Delphi and C++ Builder that allows your end-users 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 interface that allows you to build queries involving unions and sub-queries.

The interface of Active Query Builder for Delphi 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 for Delphi 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, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, and ANSI-92 SQL dialects.

The sophisticated SQL parser with full Unicode support can translate any valid SQL statement into it's visual representation. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects. Using Active Query Builder you'll be able to retrieve various information about parsed query like lists of tables and fields used in the query. Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.

Using the Active SQL Query Builder you can customize SQL code the way you like it.

There are two editions available: the Standard Edition and the Free Edition. The Free Edition is fully functional, but supports only the ANSI-92 SQL dialect.

---

Quick Query
$20 - Quick Query

Quick Query is a Plug-In for Microsoft Access. It provides a context sensitive, simple way to perform SQL queries on the fly, without creating or saving a query using the standard Query Designer.

Run multiple SQL Queries on the fly:

Quick Query allows you to have multiple windows open at once, which are hosted outside of the Access workspace.

Context Sensitive Highlighting:

The query area provides context sensitive highlighting. Keywords, restricted words and symbols, brackets and functions are all highlighted for easy identification.

Query multiple databases at once:

Each window creates its own connection to the current database open in MS Access. If the open database changes, that connection is still maintained. This allows you to query one database, while modifying another.

Manage existing Access queries:

Quick Query provides access to existing queries in the current Access database. Queries can be opened, modified and then saved back into the database. New queries can also be saved into the database. Once saved, queries can be used from within MS Access in the same way as other queries.

Create queries too complex for Access Designer:

There are certain types of more complex query that cannot be handled in the Access query designer. An example of this is trying to join 2 instances of the same table together with different aliases. Although there is a workaround in Access (using multiple queries), it is difficult to maintain over time.

View additional information about each query:

After each query has finished running, the time taken to run the query to the nearest millisecond, and the total number of records returned from the query will be displayed in the status bar.

System Requirements:

Windows Operating System (Me, 2000, XP, 2003)
MS Access 2000 or greater
Microsoft .Net Framework Version 1.1

---