Active Query Builder History v.3.3.24.1072
- Query Transformer: Applying both pagination and sort order has been fixed. = SQL Text Editor: "Dual" has been added to the list of suggestions for Oracle.
Active Query Builder History v.2.10.11.819
+ Batch loading of fields and foreign keys for Oracle, MS SQL Server and
DB2 has been implemented.
+ The new SyntaxProvider.UseBatchMetadataLoading property has been added
(default: True).
+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Query Transformer: Applying both pagination and sort order has been fixed.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- MySQL: Some valid identifiers were erroneously treated as keywords.
Fixed now.
- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions has been
added.
Active Query Builder History v.2.14.1
+ Batch loading of fields and foreign keys for Oracle, MS SQL Server and DB2 has been implemented. + The new SyntaxProvider.UseBatchMetadataLoading property has been added (default: True). - Criteria Builder: The bug with "between" operator for date fields has been fixed. - Sybase: Detection of newer versions of SQL Anywhere has been fixed. - Sybase: Case-sensitive identifiers are implied for Sybase ASE. - Query Transformer: Applying both pagination and sort order has been fixed.
Active Query Builder History v.3.3.24.1071
= The QueryStatistics.IsStatisticsValid flag has been hidden.
+ Oracle: Batch fields and relations loading has speeded up metadata
loading.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Firebird: Parsing of Aggregate functions has been fixed.
- Other improvements and bug fixes have been made.
Active Query Builder History v.3.3.24.1071
- Restoring layout of datasources in the query after manual changing the
query has been fixed.
+ The new "Go To Expression" context menu item has been added for
sub-queries in expressions.
+ New properties have been added to the AddObjectWindowOptions group:
Width, Height, Position, Location, ImageIndices.
= Query Column List: Conditions recognition and correction has been
improved.
- User Queries Structure assignment has been fixed.
= The QueryStatistics.IsStatisticsValid flag has been hidden.
+ Oracle: Batch fields and relations loading has speeded up metadata
loading.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Firebird: Parsing of Aggregate functions has been fixed.
- The bug with dragging CTE from the query navigation bar to the Design
Pane has been fixed.
= References to DevExpress controls have been updated to the version 17.2.3.
- Other improvements and bug fixes have been made.
Active Query Builder History v.3.3.24.1071
- Restoring layout of datasources in the query after manual changing the
query has been fixed.
+ The new "Go To Expression" context menu item has been added for
sub-queries in expressions.
+ New properties have been added to the AddObjectWindowOptions group:
Width, Height, Position, Location, ImageIndices.
= Query Column List: Conditions recognition and correction has been
improved.
- User Queries Structure assignment has been fixed.
= The QueryStatistics.IsStatisticsValid flag has been hidden.
+ Oracle: Batch fields and relations loading has speeded up metadata
loading.
- Oracle: Unsupported comparison operators ("!>", "!<") have been removed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Firebird: Parsing of Aggregate functions has been fixed.
- The bug with dragging CTE from the query navigation bar to the Design
Pane has been fixed.
- Other improvements and bug fixes have been made.
Active Query Builder History v.1.28.1
+ Now it's possible to add and remove rows in the Query Columns List using the Alt+Insert and Alt+Delete keyboard shortcuts, move them up and down using the Alt+[Arrow Up/Down] keys. = Sybase: Case-sensitive identifiers are used now for Sybase ASE. = Oracle: complex SQL queries parsing has been speeded up. = IBM DB2: Both LabelText and Remarks are used as LongDescription for fields for the QSYS2 schema. - The bug with keyboard navigation in the Query Columns List has been fixed. - Minor SQL formatting fixes have been made. - Minor HighDPI scaling issues have been fixed. - Query Columns List cell painting bug has been fixed. - The Links menu item captions have been restyled, the bug with a foreign key referenced to itself has been fixed. - MySQL: The bug with parsing of DateDiff and TimeDiff functions has been fixed.
Active Query Builder History v.1.28.1
+ Now it's possible to add and remove rows in the Query Columns List using the Alt+Insert and Alt+Delete keyboard shortcuts, move them up and down using the Alt+[Arrow Up/Down] keys. = Sybase: Case-sensitive identifiers are used now for Sybase ASE. = Oracle: complex SQL queries parsing has been speeded up. = IBM DB2: Both LabelText and Remarks are used as LongDescription for fields for the QSYS2 schema. - The bug with keyboard navigation in the Query Columns List has been fixed. - Minor SQL formatting fixes have been made. - Minor HighDPI scaling issues have been fixed. - Query Columns List cell painting bug has been fixed. - The Links menu item captions have been restyled, the bug with a foreign key referenced to itself has been fixed. - MySQL: The bug with parsing of DateDiff and TimeDiff functions has been fixed.
Active Query Builder History v.3.3.23.1070
- The bug with not clearing the ORDER BY clause on assigning new text to a sub-query.
Active Query Builder History v.3.3.23.1070
- Hi-DPI scaling issues have been addressed. - The bug with expanding custom metadata structure items has been fixed. - The bug with not clearing the ORDER BY clause on assigning new text to a sub-query.
Active Query Builder WinForms .NET Edition:
Active Query Builder WPF .NET Edition:
Active Query Builder ASP.NET Edition:
Active Query Builder Java Edition:
Active Query Builder ActiveX Edition:
Active Query Builder VCL Edition:
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!