Downloads  »  Active Query Builder ActiveX Edition History

April 01, 2008

Active Query Builder ActiveX Edition v.1.9.0.10

Below is the list of fixes and improvements in Active Query Builder ActiveX Edition v.1.9.0.10.

+ 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.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

Active Query Builder ActiveX Edition v.1.9.0.10 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 are added to the IActiveQueryBuilderX interface:

• SleepMode: VARIANT_BOOL; Read-only;
  Determines if Active Query Builder is currently in the Sleep mode.
• AllowSleepMode: VARIANT_BOOL;
  Allows or denies switching to Sleep mode.

The following events are added to the IActiveQueryBuilderXEvents interface:

• OnSleep, OnWake;
  Fired when Active Query Builder switches to and exits from the Sleep mode.
• OnWakeQuery ([in, out] AAllow: VARIANT_BOOL);
  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.

• IActiveQueryBuilderX.ParenthesizeANDGroups: VARIANT_BOOL;
  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)".
• IActiveQueryBuilderX.ParenthesizeSingleCriterion: VARIANT_BOOL;
  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 ActiveX Edition at the download page.

» Full Active Query Builder ActiveX Edition history