How do I add a record to an MS Acess DB using Delphi and ADO? Newbie

From: sara cox (saracox2004_at_yahoo.com)
Date: 12/27/03

  • Next message: MikeB: "Re: How do I add a record to an MS Acess DB using Delphi and ADO? Newbie" 
    Date: 26 Dec 2003 21:54:35 -0800

    Hi!

    I am a newbie and I would like to add records to an MS Access DB using
    Delphi and ADO within a DLL I wrote in Delphi 7.

    I have a DSN connection. I (obviously) don't want to use a form - the
    DLL is accessed through C# / .NET and it sends a string of data which
    needs to be committed to the Access DB.

    Right now the DLL is working and I can pass a string to it and it pops
    up with a message box with the string.

    Do I use a unit in delphi? A function? A procedure?

    If you can supply me with some simple sample code, I would greatly
    appreciate it. Thanks in advance!

    Sara :)
    xoxo

  • Next message: MikeB: "Re: How do I add a record to an MS Acess DB using Delphi and ADO? Newbie"

    Relevant Pages

    • Re: Using function with PChar data type
      ... the author of DLL just ... short STRING into a HUGE string. ... those string type into C like pointer strings. ... I tried to figure out why I could not get basic delphi pascal DLL to ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Using function with PChar data type
      ... DELPHI DLL I was using was just copying to a null terminated string ... But I was leery with the initializing and not allocating space for it. ... I was able to finally get the Delphi DLL to import and marshall correctly. ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Problem with DllImport
      ... your trouble can be caused by Delphi's string types. ... Depending on which Delphi version was used to build the DLL, ... and object is freed twice upon shutdown, or used after it has been freed. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: How do I add a record to an MS Acess DB using Delphi and ADO? Newbie
      ... sSql, sCnStr: string; ... > Delphi and ADO within a DLL I wrote in Delphi 7. ... > Right now the DLL is working and I can pass a string to it and it pops ...
      (alt.comp.lang.borland-delphi)
    • Re: How do I add a record to an MS Acess DB using Delphi and ADO? Newbie
      ... sSql, sCnStr: string; ... > Delphi and ADO within a DLL I wrote in Delphi 7. ... > Right now the DLL is working and I can pass a string to it and it pops ...
      (borland.public.delphi.database.ado)