01/23/2005Query Builder 2.94 released.
We are pleased to announce new version of Query Builder. You can download the newest version from the download page.
What's new in Query Builder 2.94?
- We have added Delphi 2005 support!
- We have implemented the TCustomQueryBuilder.CheckLinkFieldsType property to control linked fields type, checking when user creates a link by drag-and-drop operations (almost all servers allow joins with fields of different types, but errors can occur on execution).
- Added WorkAreaPopupMenu and TabsPopupMenu properties.
- TMSSQLQueryBuilder now supports constants in JOIN conditions.
- The new ActiveCaptionText and InactiveCaptionText properties to set table caption text colors are added.
- We have added GenerateUniqueFieldAliases property: if =true then when you add an already selected field to Selection tab, QB generates unique alias for this field.
- For selected field without prefix (table name/alias) QB searches for this field in all tables used in query. But if this field is not found (or this is really not a field, but complex expression) QueryBuilder fires new event OnCheckExpressions.
- TPgSQLQueryBuilder now supports ILIKE operator.
- We have fixed the bug with comlex visual JOIN'ing.
- Fixed bug with scrolling fields in small tables in designer area.
- Parsing queries when operator Display Name is changed works correctly now.
- Reserved words for MS SQL are fixed.
- Solved the problem with parsing queries with functions Left(), Right() and others (with the same names as one of the reserved words).
- Fixed bug with disappearance of GROUP BY items in some cases when parsing.
- A lot of minor improvements and bug fixes.
