Dear Sirs and Madams,

EMS HiTech Company is announcing the version 2.0 of the QueryBuilder component suite -- powerful components intended for visual building SQL statements for the SELECT clause.

You can download the newest version for Delphi 5, 6, 7 and C++Builder 5, 6 as well as compiled .exe-demos at
http://www.ems-hitech.com/querybuilder/download.phtml

What's new in version 2.0?

1. EMS QueryBuilder now is represented as a set of components designed for individual SQL dialect. At present moment there are three SQL dialects supported within EMS QueryBuilder: standard SQL, InterBase/FireBird (both Dialect 1 and Dialect 3) and MySQL.

2. New powerful parser contains all the base methods to parse the SELECT statement and allows you to override the parser methods to adapt it to any SQL dialect.

3. A possibility to customize lists of SQL keywords, functions and aggregate functions was added. This feature allows you to change the syntax-specific words within QueryBuilder depending on the SQL dialect or SQL server version.

4. New OnParserError event was added to QueryBuilder. This event allows you to handle errors, which occur during the source SQL statement parsing.

5. Support of some special structures within SQL statement was added to the parser. Among the supported structures are FIRST # SKIP # statement for FireBird, ROWS # PERCENT WITH TIES statement for InterBase 6.5 and LIMIT # statement for MySQL.

6. Some visual options, such as VisibleTabs and customization of all fonts and colors used in the QueryBuilder, were added.

7. New demo projects for Delphi and C++Builder are included to the distribution package. They demonstrate how you can manipulate component's methods and properties, and how QueryBuilder can communicate with BDE, IBX and dbExpress components.

What is the EMS QueryBuilder?

EMS QueryBuilder is a powerful component suite intended for visual building SQL statements for the SELECT clause. 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, InterBase/FireBird databases and MySQL. Using QueryBuilder you can let your
users to make up large and complicate SQL queries for different servers without any knowledge of the SQL syntax.

Main features:

- Standard SQL, InterBase/ Firebird and MySQL server support
- Borland Delphi 5, 6, 7 and C++ Builder 5, 6 support
- Detailed help system and a demo application for quicker mastering the product
- Powerful component and property editors, which allow to set easily many query building parameters at the design-time
- High productiveness 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.
- And much more... Welcome to http://www.ems-hitech.com/querybuilder/

We hope you'll enjoy working with new version of our software!
Thank you for your attention.

Best regards,
EMS HiTech Team
http://www.ems-hitech.com