New to Delphi - Connecting to database using just code

From: TD <dlee@xxxxxxxxxxx>
Date: Wed, 26 Mar 2008 20:45:09 -0700 (PDT)

I am an MS Access programmer trying to move to Delphi. In VBA I can
do the following:

1 - Create connection to database, usually using DAO.
2 - Create a recordset using a select query to return a single record.
3 - Loop throught the fields of the record, assigning the values to
the corresponding fields on the form.
4 - Delete the recordset
5- Close connection to the database

Can I do the same thing in Delphi without using any of the database
components? I know you use VCL components to work with a databases in
Delphi but do not these load the entire contents of a table into
memory, causing the application to run slow, say over a VPN connection?
.

Follow-Ups:
- Re: New to Delphi - Connecting to database using just code
  - From: Maarten Wiltink

Prev by Date: Middle pointer for double linked list.
Next by Date: Re: D2006 Object inspector component
Previous by thread: Middle pointer for double linked list.
Next by thread: Re: New to Delphi - Connecting to database using just code
Index(es):
- Date
- Thread

Relevant Pages

Re: Connection types and speeds
... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
(microsoft.public.access.queries)
Problems with ADO and Multithreading: List Index Out Of Bounds
... I've realized an application with Delphi 7 or Delphi 2006 and ADO ... connection to a Microsoft Access Database ...
(borland.public.delphi.database.ado)
Re: VBA - "Out of stack space" error
... written for AutoCAD VBA generates an 'Out of stack space' ... I create the ADODB connection... ... > ' If the connection to the database has been opened ... where I try to open the recordset. ...
(microsoft.public.vb.database.ado)
Re: adodb
... without knowing how the database is implemented. ... required to access a database when using ADO, although one can use ADO to ... A Connection object represents a unique session with a data source. ... A Recordset object represents the entire set of records from a base table ...
(microsoft.public.vb.database.ado)
Re: adodb
... > without knowing how the database is implemented. ... > required to access a database when using ADO, although one can use ADO to ... > A Connection object represents a unique session with a data source. ... At any time, the Recordset object ...
(microsoft.public.vb.database.ado)