EMS HiTech company is pleased to announce QueryBuilder 2.5 -- the next version of our powerful component suite for visual building of SQL statements.

You can download the latest version from
http://www.ems-hitech.com/querybuilder/download.phtml

What's new in version 2.5?

1. We have implemented the MS SQL dialect support in our component suite. Now you can use the TMSSQLQueryBuilder component for building queries to MS SQL server. Five SQL dialects are supported by the suite now: standard SQL, InterBase/FireBird, MySQL, PostgeSQL and MS SQL.

2. We have added a Delphi demo project for TMSSQLQueryBuilder component to the distribution package. This demo project uses ADO components to access MS SQL databases. You can find this project in the DemosDelphiADODemo directory of the distribution package.

3. QueryBuilder supports using parameters within the query text now, so parser will not raise the 'Invalid token' error in cases when parameters are used in the query.

4. Now the Sorting tab displays all query fields as available if none of the fields are included into the Selection tab.

5. Field/table names containing a dot character are quoted correctly after dragging and dropping them into the Criteria panel.

6. Fixed bug with the incorrect ORDER BY clause generation after deleting a table with alias from a diagram in some cases.

7. Fixed bug with parsing aggregates in the TInterBaseQueryBuilder component.

8. Some small improvements and minor corrections.

What is EMS QueryBuilder?

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, MySQL and PostgreSQL dialects. 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.

We hope you will like our software.
Thank you for your attention.

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