Downloads

Active Query Builder WinForms Edition History

January 26, 2011

Active Query Builder WinForms Edition v.1.14.2.263

- Oracle: EXTRACT function in XML queries is fixed.
- MySQL: missing Group_Conact aggregate function is added.
= Polish translation is updated.

January 18, 2011

Active Query Builder WinForms Edition v.1.14.1.262

- Fixed bug with main query update after CTE changed.
- MySQL: RLike and Regexp functions are fixed.

January 14, 2011

Active Query Builder WinForms Edition v.1.14.1.261

- Fixed parsing of derived tables without alias.
- Fixed parsing of joins with parentheses.

December 23, 2010

Active Query Builder WinForms Edition v.1.14.1.259

+ Arabic (Saudi Arabia) [ar-sa] translation is added.
+ Swedish [sv] translation is added.
- Bug with nested NOT expressions is fixed.
- Recursive CTE processing is improved.
- MySQL: CONVERT function is fixed.
- PlainTextSQLBuilder formatting properties are correctly expanded now 
  (in designer).

December 13, 2010

Active Query Builder WinForms Edition v.1.14.0.256

- Sql Text Editor: Fixed exception when the suggestion window is visible at the
  control disposal.
- Metadata Editor: Error on creating foreign keys with drag and drop is fixed.
- Missing strings for "Collapse" and "Expand" commands are added into "en.xml"
  translation template file.
- Source code examples are updated for compatibility with Visual Studio 2008 
  and 2010.

December 03, 2010

Active Query Builder WinForms Edition v.1.14.0.255

= Toolbox Manager is slightly improved (will hasten installation a bit).
= German, Spanish, French, Italian and Portuguese(Br) translations are updated.
= DevExpress dependencies of ActiveDatabaseSoftware.DevExpressControlFactory.dll
  are updated to v. 10.2.3.0.
= SqlTextEditor and ExpressionEditor: syntax coloring properties go public.
+ Server version auto-detection is implemented for most of database servers.
+ Renaming and removing of common table expressions (CTE) is implemented.
+ Metadata Editor: Adding and editing of virtual objects and fields is made. 
+ Images on tabs are implemented. To hide images use the ShowTabIcons property. 
  To set custom images use the TabsImageList property (must contain 4 images: 
  main query, sub-query, derived table, common table expression (CTE)).
- Oracle: Loading of materialized views is fixed.
- SqlTextEditor: AVG function highlightning is fixed for MS Access syntax.
- Firebird: DateAdd, DateDiff, Overlay, Position built-in functions are added.
- MS Access: probelm with '$' char in built-in function names is fixed, 
  problem with MS Excel sheet names quotation is solved.
- Automatic generation of aliases is fixed.

November 18, 2010

Active Query Builder WinForms Edition v.1.13.18.254

- Setting "None" to FieldListOptions.SortType now reverts to original fields sort
  order.

November 17, 2010

Active Query Builder WinForms Edition v.1.13.18.253

= Metadata Container Load Form: Loading of metadata objects and relations is
  optimized.
- Sybase: Union operators list is fixed.
- Oracle: Problem with recursive CTE is fixed.
- Oracle: Support of materialized views is added.

November 08, 2010

Active Query Builder WinForms Edition v.1.13.17.252

+ Italian translation is added.

October 28, 2010

Active Query Builder WinForms Edition v.1.13.16.250

= Some methods of the Link class goes public.
= LoadMetadataHelpers API goes public.
- Oracle: DBLinks syntax is fixed.
- Oracle: Aggregate functions for Oracle 11 are added.
- DevExpressControls: Diagram objects could not be moved outside of the diagram
  now.

Product Summary

 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:

News

Tweets

Testimonials

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!


Social networks