Home  Products  FAQ Company Contact Purchase
 
   FAQ's
Frequently Asked Questions
 


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

 

 

What does the component do ?
With the QARv2 dll component you can perform full SQL queries on any ADO Recordsets as if they existed as Tables in a Database and return the results to your application in the form of a disconnected ADO Recordset.

Top

What SQL syntax does the component support ?
The component supports MS Access SQL syntax. Please note that the Component is designed to return data results and therefore only supports the SQL SELECT command statement.

Top

Can you query ADO Recordsets from any source ?
Yes, as long as the data can be represented in an ADO Recordset you can use the component to query it.

Top

How do I identify the ADO Recordset in SQL so I can specify the fields I wish to select ?
Use the RecordsetName Property of the RecordsetCollection Add Method to identify which ADO Recordset to select the fields from, i.e. "rs1.OrderID".

I want to be able to add, remove

Top

I want to be able to add, remove and update the records returned by the component. Will the component support this ?
The populated disconnected ADO Recordset returned by the component can be any of the Cursor Types and Lock Types supported by ADO, use the CursorType and LockType properties available in the component (the default setting is ForwardOnly, ReadOnly). Because the returned ADO Recordset is disconnected it will persist for the lifetime of your application or until you choose to close it, so you are free to do whatever you like with the Recordset.

 

 

Latest News

Mar 2006
Automated-SQL-Builder v3.2
Version 3.2 released.

Now Supports Alias Tables and Fields.

Nov 2005
Query-A-Recordset v2.0
Version 2.0 released.

Automated-SQL-Builder v3.1.2
Version 3.1.2 released.

Features Multi-Language support.

Mar 2005
Automated-SQL-Builder v3.0
Version 3.0 released.

 

Latest Revisions

Existing Customers

Automated-SQL-Builder v3

v3.2.0

   
Automated-SQL-Builder v2

v2.0.5

   
Query-A-Recordset v1

v1.2.2

   


 

Copyright © 2002-2006 SBS Development - All Rights Reserved