Downloads  »  Active Query Builder WinForms Edition (1.x) History


April 03, 2008

Active Query Builder WinForms Edition v.1.5.7.97

Below is the list of fixes and improvements in Active Query Builder WinForms Edition v.1.5.7.97.

+ Sleep mode is implemented. This mode allows you to suppress error messages
  while printing unsupported statements in SQL text editor, connected with
  Active Query Builder. Active Query Builder now switches to Sleep mode when
  non-SELECT statement is passed to the SQL property. This allows your end-users
  to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ...,
  ALTER ..., etc., without any additional processing. 
+ New properties are added to parenthesize conditions in WHERE clause.
+ DB2, MS SQL, SQL2003 syntaxes: Added support for field aliases for derived
  tables.
- MSSQL syntax: WITH clause is fixed.
[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

Active Query Builder WinForms Edition v.1.5.7.97 in details


Sleep mode is implemented. This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing.

The following properties and events are added to the TacQueryBuilder component:

  • SleepMode: Boolean; Read-only;
    Determines if Active Query Builder is currently in the Sleep mode.
  • AllowSleepMode: Boolean;
    Allows or denies switching to Sleep mode.
  • SleepModeChanged
    Fired when Active Query Builder switches to and exits from the Sleep mode.
  • QueryAwake: (Object sender, ref bool abort)
    Fired when the user starts building a query (by dragging an object to the query building area) when Active Query Builder is currently in the Sleep mode. Tracking this event is important as it leads to loss of query built by the user while Active Query Builder was in this mode.

New properties are added to parenthesize conditions in WHERE clause.

  • SQLBuilder.ParenthesizeANDGroups: Boolean;
    Instructs SQL Builder to set unnecessary parenthesis for groups of conditions with high priority, separated with lower priority operators.
    Example: "(Condition1 AND Condition2) OR (Condition3 AND Condition4)".
  • SQLBuilder.ParenthesizeSingleCriterion: Boolean;
    Instructs SQL Builder to parenthesize each single criterion.
    Example: "(Condition1) AND (Condition2) OR (Condition3) AND (Condition4)".

You can always get the latest trial version of Active Query Builder WinForms Edition at the download page.

» Full Active Query Builder WinForms Edition history

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