Downloads

Active Query Builder WinForms Edition History

March 02, 2012

Active Query Builder WinForms Edition v.1.16.6.355

- SQL Text Editor: The suggestion window did not hide on focus lost. Fixed now. 
  The new HideSuggestionWindow() method is added for it's manual hiding.
= More performance optimizations are made.

February 29, 2012

Active Query Builder WinForms Edition v.1.16.6.354

= Performance optimizations are made.
= More informative XML parsing exceptions (the inner exception is correctlty
  passed to AstException wrapper).
- SQL Text Editor: Wrong tooltip height when the control is hosted in WPF
  WindowsFormsHost is fixed.
- The problem with recursive CTE is fixed.
- Oracle: Parsing of expressions like "expression IN expression" is fixed.
- Oracle: Nested multiline comments were affecting the parsing. Fixed now.

February 28, 2012

Active Query Builder WinForms Edition v.1.16.5.353

+ SQL Text Editor: Text drag and drop is implemened.
+ SQL Text Editor: The new events are added: PreProcessKey, PostProcessKey,
  PreProcessMouseDown, PreProcessMouseMove, PreProcessMouseUp.

February 21, 2012

Active Query Builder WinForms Edition v.1.16.4.352

- SQL Text Editor: The exception on showing Find dialog when the control is hosted 
  in WPF window is fixed.

February 20, 2012

Active Query Builder WinForms Edition v.1.16.4.351

- Oracle: Parsing of TABLE function is fixed.
- MySQL: Parsing of logical expressions in criteria cells is fixed.
- Changing of the QuoteAllIdentifiers and ObjectPrefixSkipping properties does 
  not clear the query any more.
= QueryStatistics.OutputColumns[i].ColumnName is always unquoted now.

February 14, 2012

Active Query Builder WinForms Edition v.1.16.4.350

- DevExpressControlFactory: The CriteriaListOptions.CriteriaListFont property did
  not affect the DevExpressCriteriaListControl font. Fixed now.
- DevExpressControlFactory: Automatic alias generation when adding fields with
  same names is fixed.

February 10, 2012

Active Query Builder WinForms Edition v.1.16.4.349

+ Field alias is used now as tab caption for expression sub-queries that are used
  as fields in the parent query. 
- DevExpressControlFactory: The Union button size and location is fixed.

February 09, 2012

Active Query Builder WinForms Edition v.1.16.4.348

+ The new syntax provider for Microsoft SQL Azure databases is added.
  (MSSQLAzureSyntaxProvider)
= SQL Text Editor: The methods to show Find/Replace dialogs are made public:
  ShowFindDialog(), ShowFindAndReplaceDialog().
= Expression Editor: The "Active sub-query" and "Metadata" tabs are swapped; 
  "Active sub-query" tab is renamed to "Query Objects". 
- Some synchronization issues of the SyncSQL property revealed in WPF
  applications are fixed.

February 06, 2012

Active Query Builder WinForms Edition v.1.16.3.346

= MS SQL Server: Now FOR XML clause can be used in subqueries too.
= Firebird: The new aggregate function LIST, WEEKDAY and YEARDAY keywords in
  EXTRACT function are added.
- The minor issue in parsing of ORDER BY clause of simple queries is fixed.
- MySQL, PostgreSQL: Loading of column precision and scale from server system
  catalogs is fixed.
- MySQL: Parsing of sub-queries in criteria cells is fixed.
- Loading of stored procedure fields is fixed.

February 02, 2012

Active Query Builder WinForms Edition v.1.16.3.345

+ SQL Text Editor and Expression Editor can be localized now using the
  QueryBuilder's Language property and its language files. The new strings to
  localize are added to the "en.xml".
= The double click on a field in a data source adds new item to the query
  columns list without marking it selected for output now.
- Synchronization issues on using the QueryBuilder.SyncSQL property in the Leave
  event of a text box are fixed.
- SQL Text Editor: Line numbers are updated properly now on the Enter key press.
- Resizing of CTE datasource located in a hidden tab when changing it's field
  list is fixed.

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:

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