このページは既にアーカイブ化され、その後の更新はありません。

この商品を購入するには、http://www.sbsdev.co.ukに移動してください。

Automated-SQL-Builder

Give your Client-Server and Web Application users the ability to create and execute their own queries.

SBS Development 社の製品

About Automated-SQL-Builder

Give your Client-Server and Web Application users the ability to create and execute their own queries.

The Automated-SQL-Builder is an ActiveX Control that can be used to provide any application with user Querying capabilities, providing a powerful addition to your overall reporting solutions. The Control contains a Tool that allows users at all technical levels to seamlessly create and execute ‘SELECT’ SQL queries in a very intuitive and natural way.

The Control contains a Tool that allows users at all technical levels to seamlessly create and execute SELECT SQL queries in a very intuitive and natural way.

No prior SQL knowledge is required, as the Tool automatically takes care of building the underlying SQL Syntax. The Tool also attempts to predetermine the users query requirements, by making assumptions based on a combination of the previously added criteria and query operators selected by the user.

"first for any Query Building Component on the Market today"

The above approach delivers truly flexible and feature rich querying capabilities to users and ensures that the assembled SQL Syntax is always correct.

The Control also features a rich array of Properties, Methods and Events, that can be used to manage the functionality available to users and the way that the tool should interact with your application.

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 & Initialisation
  • 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
  • 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 & 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