Developer Features

• Support for virtually any SQL ANSI-92 Database, including Oracle, DB2, MySQL, MS Access and SQL Server.
• Internet enhanced and enabled. Including Digital Signature and marked Safe for Scripting and Initialisation.
• Facility to change the control's User Interface language from English (default) to your local language or a language of your choice.
• Improved Control load performance when connecting to large and complex databases.
• Bind Control to a Database Connection at Design time via the Connection Property page or at Run-time by providing the necessary Connection arguments.
• Work in Bound (Database Connection) or Unbound (No Connection) mode.
• Select the Tables and Views that you wish to expose to the user.
• Supports the use of alias tables and fields. Enables you to hide native Database Table and Field names by displaying bespoke (user friendly) Table and Field names to the user.
• Add/Remove Tables and Fields at run-time.
• Position the ASB Form anywhere on the screen, hide it and set its focus using any of the new Left, Top, Visible and Set Focus Properties and Methods.
• Restrict user functionality by utilizing the control's comprehensive array of Properties, Methods and Events.
• Utilize Control in new or existing Applications and have it working in minutes.
• Control exposes User generated SQL string and query results in the form of an
  ADO Recordset.
• .NET Compatible

User Features

• Fresh ‘XP’ look and feel.

• Select Tables/Fields.

• Ability to create Table Joins.

• Support for WHERE and HAVING conditions.

• Search Database for available Field values.

• Automated assumptions based on a combination of the previously added criteria and query operators selected by the user.

• Assumptions can be edited using the versatile edit WHERE grid.

• Support for Group By Clause.

• Support for Order By Clause.

• Ability to build Calculated Fields.

• Open, Save and Delete Queries.

• Manually edit a copy of the assembled SQL using the SQL Scratch Pad.

• View Query results.

• Export Query results to Excel.

ASB Version 3 incorporates many new features and enhancements that further complement
previous versions of ASB, including the ability to use the control in both Web and Client/Server applications, an improved XP look and feel, an enhanced GUI that is both simple and intuitive to
use, the ability for the user to manually edit the assembled SQL using the new SQL Scratch pad, enhanced Database support, improvements to .NET Interop. as well as many new Developer features and enhancements.

New for Version 3.2

• New feature added to support alias tables and fields.
• Performance improvements when searching for selected field criteria values.
• New Event: QueryModified fires whenever the SQL has been changed by the user and returns a copy of current SQL.
• New Event: SearchFieldValueCriteria fires when the value search criteria button is clicked and provides an opportunity to add values. Ideal when operating in unbound mode.
• New Method: ASBGetAliasQuerySQL used to return a copy of the current alias SQL.
• New Method: ASBGetQuerySQL used to return a copy of the current Database SQL.
• UI modified to better accommodate different languages.
• New Property: ASBCriteriaValueMaxRecords used to limit the number of criteria values returned by the combo.
• New Property: ASBCriteriaValueSortAsc used to sort the combo's criteria values (desc/asc).
• Fixes to all known bugs from previous versions.

New for Version 3.1

• Facility to change the control's User Interface language from English (default) to your local language or a language of your choice.
• Vastly improved Control load performance when connecting to large and complex databases.
• Fixes to all known bugs from previous versions.

New for Version 3.0

• Internet enhanced and enabled. Including Digital Signature and marked Safe for Scripting & Initialisation.
• New improved GUI that is even more intuitive to the user and offers a new and fresh ‘XP’ look & feel.
• Enhanced functionality & flexibility to cater for users at all levels.
• Ability for users to manually edit the assembled SQL using the newly added SQL Scratch Pad. Edited SQL can be executed in the same manner as assembled SQL. Users can also save and call up previously saved SQL.
• Improved WHERE criteria grid, now makes it even easier for users to edit Query criteria by allowing them to optionally select only the Fields that contain criteria.
• Users can now Shrink and Expand the SQL Window & WHERE criteria grid, making it easier for users to read and edit assembled Queries.
• Users can now change the order of Selected Fields easily without having to deselect & reselect them.
• Enhanced support for ANSI-92 compliant Databases, including improved interaction with Oracle 9i and above.
• Enhanced Database Connection options & improved Database Connection performance.
• Position the ASB Form anywhere on the screen, hide it and set it’s focus using any of the new Left, Top, Visible and Set Focus Properties and Methods.
• Enhanced reporting features that allow the built in Excel export feature to be triggered at any time, providing that assembled user SQL and active Connection are available.
• COM interop. enhancements including a fix for the .NET Framework 1.1 (sp1) ‘Object type cannot be converted to target type’ runtime error.
• Enhanced Component Model which is even more intuitive and flexible to the Developer, includes many new Properties, Methods and Events as well as enhancements to existing ones.
• Enhanced demo applications including both Web & Client/Server demo apps.
• Includes detailed example code for VB6, VB.NET, VBScript, ASP.NET and C#.NET languages.
• Fixes to all known bugs from previous versions.