Online Documentation for Advanced Query Builder for RAD Studio VCL

Version history

 

         Version 3.13

• Support for RAD Studio 11 Alexandria added.

 

         Version 3.12

• Support for RAD Studio 10.4 Sydney implemented
• Added support for parameters in JOIN ON expression
• Fixed editing of columns data on the Selection tab
• Fixed parsing of subqueries in the WHERE clause
• End of support for RAD Studio 2009 and older versions
• Other minor fixes and improvements

 

             Version 3.11.1

• Support of RAD Studio 10.3 Rio implemented

 

          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.

 

 Version 3.10.3

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

 

 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

 

 Version 3.10

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

 

 Version 3.9.2

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

 

 Version 3.9.1

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

 

 Version 3.9

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

 

 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.

 

 Version 3.6

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

 

 Version 3.5

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

 

 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

 

 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

 

 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

 

 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

 

---