Active Query Builder History v.1.6.5.113
- Retrieval of the field list for derived tables is fixed.
Active Query Builder History v.1.6.5.111
+ Ability to define custom expression builder for the Expression and Criteria columns of the Criteria List is made. To activate this option, you should set the UseCustomExpressionBuilder property to true and add an event handler for the CustomExpressionBuilder event. See the "CustomExpressionBuilder" demo. - MySQL syntax: query parameters parsing is improved.
Active Query Builder History v.1.6.2.110
+ New events are added to perform additional processing when objects are added
to the Metadata Container.
* QueryBuilder.MetadataContainer.MetadataObjectAdded: Occurs after a metadata
object is added in the metadata container. You may use this event to set
additional object properties, such as alternate name, description, etc.
* QueryBuilder.MetadataContainer.ObjectMetadataLoading: Occurs before loading
of the field list of specified metadata object. You may handle this event
to override the default field list loading procedure and load field lists
for all objects of your database.
* QueryBuilder.MetadataContainer.ObjectMetadataLoaded: Occurs after loading
of the field list of specified metadata object. You may handle this event
to load field lists for those objects of your database, for what the
component was failed to load it using the default field list loading
procedure. Also you may specify additional field properties, such as
alternate name, description, etc.
Active Query Builder History v.1.6.1.109
- The component was crashing on dispose when parsed some complex queries. Fixed now.
Active Query Builder History v.1.6.1.108
- AddObjectForm did not show alternate object names. Fixed now. = Alternate names are automatically applied to field aliases now.
Active Query Builder History v.1.9.1.8
+ Working with Excel and Text files through the MS Jet Engine is improved. + Aliases for derived tables are created unique now. + Few comments are added to the Query Modification Demo. + An example of analysis of WHERE clause using AST added to the Non-Visual Demo. - Incorrect switching to the sleep mode in few occasions is fixed. - OnActiveSubQueryChanged event did not fire in some cases. Fixed now. - More correct representation of "NOT EXISTS" clause is made. - Fixed bug with saving tables with "synonym" tag in XML. - Minor bugfixes for MS Access, Firebird and Postgres syntaxes are made. + Minor speed improvements are made.
Active Query Builder History v.1.9.1.8
+ Working with Excel and Text files through the MS Jet Engine is improved. + Aliases for derived tables are created unique now. - Incorrect switching to the sleep mode in few occasions is fixed. - More correct representation of "NOT EXISTS" clause is made. - Fixed bug with saving tables with "synonym" tag in XML. - Minor bugfixes for MS Access, Firebird and Postgres syntaxes are made. - The Connect method didn't raise an error if the user clicks "Cancel" button at the Login prompt. Fixed now. + Minor speed improvements are made.
Active Query Builder History v.1.6.1.107
+ All C# source code samples are ported to VB.NET. = Non-Visual and Qurey Modification demos are updated. - Minor bugfixes are applied.
Active Query Builder History v.1.6.1.104
- IndexOutOfRangeException in the PostgreSQL syntax is fixed.
Active Query Builder History v.1.6.1.103
- Minor bugfixes.
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!