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