Delphi-Kylix
  Home arrow Delphi-Kylix arrow The ADOQuery Component
Dev Articles Forums 
ADO.NET  
Apache  
ASP  
ASP.NET  
C#  
C++  
ColdFusion  
COM/COM+  
Delphi-Kylix  
Design Usability  
Development Cycles  
DHTML  
Embedded Tools  
Flash  
Graphic Design  
HTML  
IIS  
Interviews  
Java  
JavaScript  
MySQL  
Oracle  
Photoshop  
PHP  
Reviews  
Ruby-on-Rails  
SQL  
SQL Server  
Style Sheets  
VB.Net  
Visual Basic  
Web Authoring  
Web Services  
Web Standards  
XML  
Dedicated Servers  
Download TestComplete 
IBM® developerWorks 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
IBM Rational Software Development Conference
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
DELPHI-KYLIX

The ADOQuery Component
By: Jacques Noah
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 2
    2006-10-09

    Table of Contents:
  • The ADOQuery Component
  • ADOQuery Component
  • A Practical Example
  • Dynamic Queries

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
     
    ADVERTISEMENT

    Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!

    The ADOQuery Component
    (Page 1 of 4 )

    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.

    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.

    More Delphi-Kylix Articles
    More By Jacques Noah


       · I hope you found my article educational; I welcome your comments.
     

    DELPHI-KYLIX ARTICLES

    - Client Dataset: Working with Data Packets an...
    - Using the Client Dataset in an N-Tiered Appl...
    - Using the Client Dataset in Two-Tiered Clien...
    - Using the Client Dataset in File-Based Archi...
    - Demystifying the Client Dataset
    - Working with INI Files in Delphi
    - Creating Data Link (UDL) Files in Delphi
    - Looking at the Details for an Invoicing Appl...
    - Invoicing in Delphi: Show Me the Money
    - Saving Images and Binary Files to a Database...
    - Saving Files to a Database using Delphi: Sav...
    - Creating CF Applications and Integrating a S...
    - Using Try and Finally to Help Prevent Memory...
    - The Implementation of an FTP Server
    - FTP Server: The Theory


     
    Accelerating Trading Partner Performance
     
    Competing on Analytics
     
    Cost Effective Scaling with Virtualization and Coyote Point Systems
     
    Five Checkpoints to Implementing IP Telephony
     
    Hosted Email Security: Staying Ahead of New Threats
     





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway