|
What is it ?
How is it different from other Query Builder Controls on the Market
?
Can the user Save, Open and Edit assembled Queries ?
Can I decide what functionality and options should be exposed to
users by the Control ?
Can the assembled SQL be edited manually by the user ?
How easy is it to incorporate the Control into my project ?
What Database’s are supported by the Control ?
Can the Control be used in Unbound Mode (No Database Connection) ?
Can I use the Control in a Web Application ?
Can I use the Control with ASP ?
Can I use the control in .NET?
What does the component do ?
What SQL syntax does
the component support ?
Can you query ADO
Recordsets from any source ?
How do I identify the
ADO Recordset in SQL so I can specify the fields I wish to select ?
I want to be able to
add, remove and update the records returned by the component. Will
the component support this ?
What is it ?
The Automated-SQL-Builder Version 3.0 gives
your Client-Server and Web Application users the ability to create
and execute their own Database 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.
Top
How is it different from other Query Builder Controls on the Market
?
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.
“A 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.
Top
Can the user Save, Open and Edit assembled Queries ?
Yes, the
Control features optional functionality that allows users to Save,
Open and Delete assembled Queries. A special “.asb” file type will
be created each time a Query is saved. The location of the Query can
be decided by the user or influenced by the host application.
Top
Can I decide what functionality and options should be exposed to
users by the Control ?
Yes, the Control 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.
Top
Can the assembled SQL be edited manually by the user ?
Yes, you can
optionally allow 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.
Top
How easy is it to incorporate the Control into my project ?
One overwhelming advantage of ASB is that it will dramatically
reduce your overall development time, that’s because you can be up
and running in only a few minutes, just drop the control onto a
form, open the property page and make a connection to your database,
select the tables, add a button to load ASB, add a couple of lines
of code, load the form, press the button and you’re finished.
Top
What Database’s are supported by the Control ?
Most SQL Ansi-92 compliant Database’s are supported by
the Control, including SQL Server, Access, Oracle 9i +, DB2 and
MySQL.
Top
Can the Control be used in Unbound Mode (No Database Connection) ?
Yes, a Database Connection isn’t required to use the Control. Just
add the Tables and Fields that you wish to Query and any SQL Syntax
related constraints using the Properties and Methods provided and
the Control will take care of the rest.
Top
Can I use the Control in a Web Application ?
Yes, ASB v3.0
has been enhanced for web use and Includes a Digital Signature and
has been marked Safe for Scripting & Initialisation.
Because ASB
v3.0 is an ActiveX Control, it will need to reside on any Client
machine wishing to use a web application that utilizes the Control,
therefore to achieve this, the retail copy of ASB v3.0 includes a
CAB file (ASBv3.CAB) that contains both the Control and it’s
dependency files ready for web deployment and installation on the
Client.
Top
Can I use the Control with ASP ?
Yes, the
control can be used with both ASP Classic and ASP.NET. Please be
aware that because the Component is an ActiveX Control, it will need
to be installed on the Client Machine. (See comments above).
Top
Can I use the control in .NET?
Yes, ASBv3 has been enhanced for .Net use via .Net's COM Interop.
The Product includes sample code for VB.NET, ASP.NET and C#.NET.
Top
|
