Re: How to add a new colomn in Access Table using VFP8

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Anders Altberg (x_pragma_at_telia.com)
Date: 02/08/05


Date: Tue, 8 Feb 2005 17:48:23 +0100

h = SQLCONNECT(your_mdb')
SQLEXEC(h, "ALTER TABLE xxx ADD COLUMN yyy CHAR(20)" )
-Anders

"Zahid Maqsood" <zahid***@hotmail.com> wrote in message
news:#DtYyZODFHA.2288@TK2MSFTNGP14.phx.gbl...
> Hi Guys,
>
> I am working on Access 97 Database and need to add a new coloumn in one of
> the tables existing in access database. I dont have copy of Access 97.
>
> Please guide me if there is any way to add a new coloumn or if there is
any
> way to change the structure of tables in Access using VFP8.
>
> Thanx.
>
> --
> _________________________________________
> Zahid Maqsood
> zahid***@hotmail.com
> zahid***@yahoo.com
> itmanager@crescentsugar.com
>
>
>


Quantcast