Re: Adding a new field to an exsisting database

Article View: borland.public.cppbuilder.database.ado

Article #3214

Back to borland.public.cppbuilder.database.ado Previous Next

#3214

From: Joe Thompson
Date: Tue, 10 Dec 2002 04:28

24 lines
1590 bytes

Hi Bob,

You can use the ALTER TABLE statement.  For example, I created an ADOQuery
with the following SQL.  If you call ExecSQL() it will add an integer field
named 'Age' to the 'People' table in an Access database:

ALTER TABLE
  People
ADD Age Integer

Hope this helps,
Joe

"Bob Grabau" <robert_a_grabau@icpmech.navy.mil> wrote in message
news:a4h9vusj0568sp2l3rfrgl1qadbh200d8q@4ax.com...
> Hello All,
> Is ther a way to add a field (column) to an exsisting database?  I'm
> using BCB6 Pro with Update 1 and 2 installed.  The database is an
> Access 97 / 2K.
>
> Thanks in advance,
>
> Bob
>

Technical Details

Message-ID: <3df56d01$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

References: <a4h9vusj0568sp2l3rfrgl1qadbh200d8q@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d32160ba8e278e1
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-09 20:36:24 PST
From: "Joe Thompson" <joelizthompson@attbi.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <a4h9vusj0568sp2l3rfrgl1qadbh200d8q@4ax.com>
Subject: Re: Adding a new field to an exsisting database
Date: Mon, 9 Dec 2002 20:28:22 -0800
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 24.126.100.79
Message-ID: <3df56d01$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039494401 24.126.100.79 (9 Dec 2002 20:26:41 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message