Newby Database questions

From: Wonko the Sane (noone_at_nowhere.com)
Date: 02/23/05

  • Next message: Raptor: "Re: Suggestions for decoupling units?" 
    Date: Thu, 24 Feb 2005 08:28:10 +1100

    Hi all,

    I have a newby question that I hope some kind person will be able to
    help me with.

    I have a simple database as an access file that I wish to use in a
    Delphi program. At the moment I am using the ADO extension to read it
    in. What I want to be able to do is create a copy of the database that I
    can use to display data while I have the originally loaded in version
    that I can add too and delete from in a different part of the program. I
    have tried to accomplish this using an SQL query but it doesn't seem to
    be working the copy is created but it seems to be populated with the
    right number of items but they are all empty.

    If it helps my database is simply a list of memo types containing short
    notes. I want to be able to edit this list while at the same time
    cycling through a copy of this list which is refreshed periodically from
    the original. (if that makes sense)

    Can anyone point me in the right direction?

    Cheers
    Wonko the Sane

  • Next message: Raptor: "Re: Suggestions for decoupling units?"

    Relevant Pages

    • Re: Field captions from MS Access
      ... field definition. ... I'm writing a Delphi program that accesses an MS Access ... database through ADO. ... database to the DisplayLabel property of the TField components in Delphi. ...
      (borland.public.delphi.database.ado)
    • Re: Newby Database questions
      ... > Delphi program. ... At the moment I am using the ADO extension to read it ... What I want to be able to do is create a copy of the database that I ... IOW you can have multiple datasets of the same table open ...
      (alt.comp.lang.borland-delphi)
    • Field captions from MS Access
      ... MS Access offers the possibility to specify a caption for each field in the ... field definition. ... I'm writing a Delphi program that accesses an MS Access ... database to the DisplayLabel property of the TField components in Delphi. ...
      (borland.public.delphi.database.ado)
    • NT server & Win2000 client problem
      ... We made a Delphi program witch uses Com-objects and a paradox database. ... De client has a Win NT sever and a Win 2000 client. ... Problem is that the database is shared so it needs to be on the server. ...
      (comp.lang.pascal.delphi.misc)
    • Re: Database Results Wizard Error Message
      ... > I would any other access file with ASP pages. ... > SQL statement to query the file. ... >> database when you get this error. ...
      (microsoft.public.frontpage.client)