EMS logo

Products Navigation

Advanced Query Builder

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Advanced Query Builder

On-line Documentation

Version history


Product name

Version

Release date

Advanced Query Builder

Version 3.11

April 27, 2017

Advanced Query Builder

Version 3.10.4

May 31, 2016

Advanced Query Builder

Version 3.10.3

November 10, 2015

Advanced Query Builder

Version 3.10.2

May 12, 2015

Advanced Query Builder

Version 3.10

April 17, 2015

Advanced Query Builder

Version 3.9.2

May 16, 2013

Advanced Query Builder

Version 3.9.1

March 29, 2013

Advanced Query Builder

Version 3.9

October 10, 2011

Advanced Query Builder

Version 3.8

December 29, 2010

Advanced Query Builder

Version 3.6

December 2, 2009

Advanced Query Builder

Version 3.5

December 8, 2008

Advanced Query Builder

Version 3.3

October 22, 2007

Advanced Query Builder

Version 3.2

April 19, 2007

Advanced Query Builder

Version 3.1

October 24, 2006

Query Builder 2005

Version 3.0

October 5, 2005

 

 

Full version history is available at http://www.sqlmanager.net/en/products/tools/querybuilder/news

 

          Version 3.11

 

  • Support for RAD Studio 10.2 Tokyo added.
  • Support for 64-bit Windows target platform added.
  • Selected columns are scrolled correctly now.
  • The direction of JOIN link has been changed on the diagram.
  • Sometimes the error occurred in applications on Windows 10. Fixed now.
  • Other minor bugfixes.

 

 Version 3.10.4

 

  • Added support of Embarcadero RAD Studio 10.1 Berlin.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.10.3

 

  • Added support of Embarcadero RAD Studio 10 Seattle.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.10.2

 

  • Support of RAD Studio XE8
  • There was the error parsing the string concatenation '||' operator (for PostgreSQL). Fixed now.
  • Now the query is cleared correctly when closing the previously selected table.
  • The support of the nested expressions is enhanced
  • Localizations mistakes are fixed

Scroll to top

 

 Version 3.10

 

  • Added support of Embarcadero RAD Studio XE7.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.9.2

 

  • Added support of Embarcadero RAD Studio XE4.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.9.1

 

  • Added support of Embarcadero RAD Studio XE3.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.9

 

  • Added support of Embarcadero RAD Studio XE2.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.8

 

  • The support of Embarcadero RAD Studio XE is added.
  • Added the possibility to select and delete several fields simultaneously at the Selection tab.
  • Added the possibility to change the fields order using Drag and Drop at the Selection tab.
  • Added the possibility to select and move several fields simultaneously at the Sorting tab.
  • The Clear method of the component now resets the query type to Select.
  • Now you can switch to the edit mode for table cells at the Selection tab by mouse double-clicking.
  • Fixed an error which occurred when loading a diagram with a query consisting of more than 10500 characters.
  • Fixed some errors of redrawing the component during scrolling.
  • Fixed the “Access violation” error occurred in the LoadFromIni method in Delphi XE.
  • Queries like “SELECT TOP (100) …” are now parsed correctly.
  • Some minor bug-fixes and improvements.

Scroll to top

 

 Version 3.6

 

  • RAD Studio 2010 support is added
  • Minor improvements and bug-fixes

Scroll to top

 

 Version 3.5

 

  • RAD Studio 2009 support is added
  • Minor improvements and bug-fixes

Scroll to top

 

 Version 3.3

 

  • RAD Studio 2007 support is added
  • Constant values in select list sometimes were not parsed. Fixed now
  • Improved parsing of GROUP BY clause
  • Minor bug-fixes in the "Selection" grid
  • Minor improvements and bug-fixes

Scroll to top

 

 Version 3.2

 

  • Delphi 2007 support is added
  • Support of diagrams saved in old format is implemented
  • Support of JOIN statement (Oracle) is added
  • Parsing of Table hints (MS SQL Server) is implemented
  • Arguments of functions were not parsed correctly in some rare cases (Oracle). Fixed now
  • Added parsing of field aliases in <field_name> "<alias>" format (Oracle)
  • Joins with AND keyword were not parsed correctly in some cases. Fixed now
  • Some table names (with '.' in names) were not recognized correctly. Fixed now
  • Some joins were not removed correctly while dropping table. Fixed now
  • Minor improvements and bug-fixes

Scroll to top

 

 Version 3.1

 

  • Support of CASE statement implemented
  • The ability to edit ORDER BY items added. Now you can use custom expressions for order by clause
  • The ability to sort by fields that are not included in select list is added
  • Functions in INSERT, UPDATE statements are parsed correctly now
  • The TRUE keyword in WHERE clause is parsed properly now
  • In some rare cases the ORDER BY statements were not parsed correctly. Fixed now
  • The OldStyleLook property added. It allows the user to hide some extended visual features
  • Tabs are now displayed correctly
  • Ability to select fields on the Criteria tab using keyboard is added
  • The items in Query Type combobox were not displayed in some cases. Fixed now
  • It was impossible to apply some colors from Query Builder Palette. Fixed now
  • The name of output field used to change when Aggregate function was selected. Fixed now
  • The UNION context menu was displayed incorrectly in some cases. Fixed now
  • Selection list used to reset when inserting/deleting fields in some cases. Fixed now
  • The IN statement with multiple values is parsed correctly now
  • Dropping Field to the Criteria panel creates a new condition row automatically
  • The state of relation lines between joined tables is now saved
  • When resizing the Query Builder window, an error used to occur. Fixed now
  • The AV error that occurred on adding/removing subqueries is fixed now
  • Fixed the error with parsing SYSDATE function
  • Fixed the error with parsing DATEPART function
  • Aliases in "and" quotes are parsed correctly now
  • Parsing of ASC keyword in ORDER BY clause is added
  • Parsing of ROWID identifier in Oracle is added
  • Query Builder locked out in some cases. Fixed now
  • Support of BDS 2006 С++ Builder is added

Scroll to top

 

 Version 3.0

 

  • Standard SQL, InterBase/Firebird, MySQL, PostgreSQL, Oracle, DB2, and DBISAM support
  • Borland Delphi 5, 6, 7, 2005 and C++ Builder 5, 6 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
  • Ability to create queries with unions and subqueries
  • High productivity even on slow computers
  • Powerful SQL parser, which allows you to represent complicate SQL statements visually
  • Ability to easily create TxxxQueryBuilder components  for working with the chosen server
  • Full customization of font colors, object appearance, etc.

Scroll to top

 

 


See also:

What's new