Re: New to Delphi - Connecting to database using just code

"TD" <dlee@xxxxxxxxxxx> wrote in message
news:2a9f816f-6682-4413-8455-76ffecba8837@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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?

Yes. Import the DAO type library and code away. We have an application
that does just that. It starts from DBEngine, then goes on to Database
and Recordset interfaces. Works fine without a component in sight.


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?

Not necessarily. Not even usually, I'd guess.

Groetjes,
Maarten Wiltink




.

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)
  • Re: Knowledge Base Help Not working
    ... Database is a DAO object. ... both Access 2000 and 2002 use ADO. ... Microsoft DAO 3.6 Object Library, ... For example, to ensure that you get a DAO recordset, you'll need to ...
    (microsoft.public.access.formscoding)
  • 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: ADO vs DAO
    ... You are trying to create a recordset using the Database object, which is DAO. ... Dim rstMyRecord As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • 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)