Automated-SQL-Builder - Summary
by SBS Development - Product Type: Component / ActiveX OCX
Please note: This page has been retired.
We no longer sell SBS Development products, please visit their web site instead:
To view alternative products, please see the following:
Categories
Best Sellers
in SQL
Other information on this page is shown for historical reference only and may have changed considerably since.
Summary
Automated-SQL-Builder by SBS Development
URLs: automated-sql-builder, automated sql builder, automatedsqlbuilder, sbs-development, sbs development, sbsdevelopment
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
What's new for V3.2x?
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
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)
UI modified to better accommodate different languages
Various bug fixes (See product history file for details)
What's new for V3.1 ?
New Facility added 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
What's new for V3.0 ?
ASB V3.0 incorporates many new features and enhancements that further compliment 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.
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 its 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 ASB 2.0.5 bugs
Give your Client-Server and Web Application users the ability to create and execute their own queries.
Evals & Downloads: Browse the Automated-SQL-Builder Screenshots Web page, Read the Automated-SQL-Builder Revision History document
Operating System for Deployment: Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95, Windows NT 3.51
Architecture of Product: 32Bit
Product Type: Component
Component Type: ActiveX OCX
Built Using: ActiveX Framework
General: Internet Enhanced, Includes Digital Signature, Marked as Safe for Scripting, Marked as Safe for Initialization, OCX96 Compatible, Supports Component Categories, Supports Apartment Model Threading
Compatible Containers: Microsoft Visual Studio .NET, Microsoft Visual Studio 6.0, Microsoft Visual Studio 97, Microsoft Visual Basic .NET, Microsoft Visual Basic 6.0, Microsoft Visual Basic 5.0, Microsoft Visual C++ .NET, Microsoft Visual C++ 6.0, Microsoft Visual C# .NET, Microsoft Office XP, Microsoft Office 2000, Microsoft Office 97, Microsoft Access 2002, Microsoft Access 2000, Microsoft Access 97, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, Microsoft SQL Server 6.5, .NET Framework 1.0
Product Class: Business Components
Keywords: atomatedsql, automated sql builder
SQL query language
Database DB Reporting Report reports
