Home arrow Delphi-Kylix arrow The ADOQuery Component
DELPHI-KYLIX

The ADOQuery Component


In the previous article, we discussed how to use the ADO components and we created an example program using an ADOTable component. In this article we are going to discuss the ADOQuery component and how it can help us deal with data manipulation in an ADO database.

Author Info:
By: Jacques Noah
Rating: 5 stars5 stars5 stars5 stars5 stars / 10
October 09, 2006
TABLE OF CONTENTS:
  1. · The ADOQuery Component
  2. · ADOQuery Component
  3. · A Practical Example
  4. · Dynamic Queries

print this article
SEARCH DEVARTICLES

The ADOQuery Component
(Page 1 of 4 )

Introduction

SQL is an acronym for Structured Query Language. It is a language that is used to interrogate a database. SQL gives us the flexibility to retrieve information in a variety of ways from a database. It takes the form of a command language that lets you select, insert, update and find the location of data, and so forth.

ADOQuery has a SQL property (as you will see later on in the article) that is used to store SQL statements. Queries can be divided into two categories: those that produce results, such as the SELECT statement, and those that donít such as the DELETE or INSERT statements. They are also executed in different ways:

  • Query.open is used to execute those that produce results.
  • Query.execSQL is used to execute those that donít produce results.

The SQL statements can be either static or dynamic, that is, they can be set at design time or include parameters (Query.Params) that vary at run time. Using parameterized queries is very flexible, because you can change a user's view of and access to data on the fly at run time. This gives you more flexibility to retrieve only the exact data that you require, instead of everything in the database, such as when using an ADOTable component. It is also worth mentioning that you can do everything that an ADOTable does and more with an ADOQuery dataset.


blog comments powered by Disqus
DELPHI-KYLIX ARTICLES

- Loading an XML Document into the DOM
- Delphi Wrapper Classes and XML
- Delphi and the DOM
- Delphi and XML
- Internet Access: Client Service
- Finishing the Client for an Internet Access ...
- The Client for an Internet Access Control Ap...
- User Management for an Internet Access Contr...
- Important Procedures for an Internet Access ...
- Server Code for an Internet Access Control A...
- Constructing the Interface for an Internet A...
- Building a Server Application for an Interne...
- Building an Internet Access Control Applicat...
- Client Dataset: Working with Data Packets an...
- Using the Client Dataset in an N-Tiered Appl...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials