Add column to an Access table ?

Article View: borland.public.delphi.database

Article #2059

Back to borland.public.delphi.database Previous Next

#2059

From: Henrik Poulsen
Date: Thu, 03 Sep 1998 00:00

28 lines
1379 bytes

Hi

I have this Access97 table which is NOTempty. And I have to add a column to
the table.

If I use

Table1.Close;
Table1.FieldDefs.Add('New column',ftString,255,FALSE)
Table1.CreateTable;

Then all the records in the table disappears (which is understandable since
CreateTable is used).

My question is:

Is it possible to add a column (using Delphi!) without deleting the records
in the table ?


I use Delphi4 Standard (= no access to the dbi-functions) and BDE 5.0



Thanks in advance


Henrik T. Poulsen

Technical Details

Message-ID: <6smbnf$814$1@dalen.get2net.dk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,233c2156764d02ac,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,233c2156764d02ac,start
X-Google-Attributes: gid115d96,public
X-Google-Thread: ff75c,233c2156764d02ac,start
X-Google-Attributes: gidff75c,public
From: "Henrik Poulsen" <henriktp@get2net.dk>
Subject: Add column to an Access table ?
Date: 1998/09/03
Message-ID: <6smbnf$814$1@dalen.get2net.dk>
X-Deja-AN: 387508560
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@get2.net
X-Trace: dalen.get2net.dk 904835631 8228 195.82.200.175 (3 Sep 1998 15:13:51 GMT)
Organization: Tele2 Internet Kunde
NNTP-Posting-Date: 3 Sep 1998 15:13:51 GMT
Newsgroups: borland.public.delphi.database,borland.public.delphi.database.desktop,comp.lang.pascal.delphi.databases