Ado and creating tables

From: Jeff Howard (jhoward_at_cubiscan.com)
Date: 01/18/05

  • Next message: Rick: "Re: Ado and Client Datasets" 
    Date: Tue, 18 Jan 2005 15:08:37 -0700

    I am porting from using the BDE and Paradox to using ADO and Access.

    Is there a way to create tables similar to how it could be done with the BDE
    for example

    with FieldDefs do
        begin
          Clear;
          //Add('Sequence', ftAutoInc, 0,True);
          Add('Item Number', ftString, 20, False);

    ....

    or do I need to use an ADO query component and use a sql Create Table
    statement to create a new table within an existing Access mdb file?

  • Next message: Rick: "Re: Ado and Client Datasets"

    Relevant Pages

    • D7 & ADO with ASA9: EOLEException & Multiple-step error
      ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
      (borland.public.delphi.database.ado)
    • Re: BDE support??
      ... > We have an application that is using controls descended from TDatabase, ... > we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Very nice for unit testing, ...
      (borland.public.delphi.non-technical)
    • Re: Conversion from BDE to ADO
      ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
      (borland.public.delphi.database.ado)
    • ADO and BDE interact on XP SP2?
      ... It uses the BDE ... indirectly to connect to a database. ... also optionally uses ADO to connect directly to the database for ... but of course any built in initialisation will have taken place. ...
      (borland.public.delphi.database.ado)
    • Re: Enhancing ADO Performance
      ... > currently have applications constructed to retrieve data from ODBC ... > worked with both because of the installation issues when using the BDE ... It seems that ADO ... of data and hooking to a DB grid, use a server-side cursor. ...
      (borland.public.delphi.database.ado)