🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Adding colunms

#2341
From: Lee
Date: Tue, 26 Aug 2003 08:55
24 lines
1526 bytes
I have been able to find out it is Alter Table, but I am unsure of the
syntax, and what component calls it, is it TADOQuery->SQL->Text = "ALTER
TABLE MyTableName [ITEM] Int"

if it is that, it is not working for me..

thanks.

Lee
"Lee" <gobroski@elltel.net> wrote in message
news:3f4b072b$1@newsgroups.borland.com...
> First I want to thank you for all the help that I have received, it has
been
> a BIG assistance.
>
> THANKS
>
> Now, how do I add a new column to an access database using ado components.
> I have been reading the Developers Guide and that is a little hazy on the
> process.  Thank you
>
> Lee
>
>
Technical Details
Message-ID: <3f4b2060$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail
References: <3f4b072b$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3ba3e8a57180a798
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-08-26 02:01:03 PST
From: "Lee" <gobroski@elltel.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3f4b072b$1@newsgroups.borland.com>
Subject: Re: Adding colunms
Date: Tue, 26 Aug 2003 01:55:00 -0700
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 12.18.161.26
Message-ID: <3f4b2060$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1061888096 12.18.161.26 (26 Aug 2003 01:54:56 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail