ADODataset vs ADOQuery

From: Nikola Jolovic (zjolovic_at_ptt.yu)
Date: 12/17/04 

Date: 17 Dec 2004 14:22:34 -0800

When I need to retrieve some data from database with the
following SQL statement:

Select * From MyTable where MyField='SomeValue';

which component is better to use - ADODataset or ADOQuery?
Mainly, what is the difference?

Regards,
           Nikola Jolovic

Relevant Pages

  • Re: Datetime within past week
    ... Prior to adding a new record to the database, I want to run a query to ... retrieve all of the records uploaded in the last 7 days. ... use dateto format and put into your sql statement. ...
    (comp.lang.php)
  • Re: ADODataset vs ADOQuery
    ... >When I need to retrieve some data from database with the ... >following SQL statement: ... >which component is better to use - ADODataset or ADOQuery? ...
    (borland.public.delphi.database.ado)
  • Re: Help - Timing Logic
    ... from the database ... ... now you either need to incorporate a locking procedure ... ... opposed to building the transaction in the code. ... implement as above locking only the records you retrieve / update - need ...
    (microsoft.public.dotnet.languages.vb)
  • Re: OT: MySQL versus PostgreSQL and database design
    ... to retrieve all the events at once. ... can make that a primary key in the database. ... likely to want to retrieve all at once, without any sorting. ... different the event types are -- if they've all got exactly the same ...
    (rec.crafts.metalworking)
  • Re: ADO data control
    ... Another way to test your query would be to try ... instinctively think that the database is probably not normalized. ... written on the topic of normalization, and one you might like is "Database ... Then the SQL statement and the existing WHERE and ORDER BY calculations ...
    (microsoft.public.vb.controls)