Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Nadeem Shah
  Where is Nadeem Shah?
 Rawalpindi
 Pakistan
 Nadeem Shah
 To: Mike Gagnon
  Where is Mike Gagnon?
 Pointe Claire
 Canada
 Mike Gagnon
 Tags
Subject: RE: Remove Stru
Thread ID: 416257 Message ID: 416272 # Views: 51 # Ratings: 0
Version: Visual FoxPro 9 Category: VFP and .NET
Date: Thursday, December 25, 2014 3:53:41 PM         
   


> >
> >
> >
*add field
> > ALTER table products ADD COLUMN sobook l DEFAULT .f.
> > ALTER table billing ADD COLUMN  name c(30)
> > 
> > *drop field
> > Alter Table products drop COLUMN sobookr
> > Alter Table products drop COLUMN name
> > 

> >
> > Nadeem Shah
>
>
 ALTER table products ADD COLUMN sobook l DEFAULT .f.
>  Alter Table products drop COLUMN sobookr
> 

>
> This will most likely cause an error.
>
> Mike Gagnon

Just for two examples on the same field name, one for how to add and other for how to delete

What type of error? Just try and found no error.

Nadeem Shah

ENTIRE THREAD

Remove Stru Posted by sandeep singh @ 12/25/2014 7:06:54 AM
RE: Remove Stru Posted by Jun Tangunan @ 12/25/2014 8:01:05 AM
RE: Remove Stru Posted by sandeep singh @ 12/25/2014 8:20:47 AM
RE: Remove Stru Posted by Nadeem Shah @ 12/25/2014 11:19:23 AM
RE: Remove Stru Posted by Mike Gagnon @ 12/25/2014 1:24:14 PM
RE: Remove Stru Posted by Nadeem Shah @ 12/25/2014 3:53:41 PM
RE: Remove Stru Posted by Mike Gagnon @ 12/26/2014 1:34:55 PM
RE: Remove Stru Posted by Nadeem Shah @ 12/26/2014 5:47:39 PM
RE: Remove Stru Posted by Tore Bleken @ 12/25/2014 12:38:42 PM
RE: Remove Stru Posted by Vivek Deodhar @ 12/26/2014 8:09:16 AM
RE: Remove Stru Posted by Manish Swami @ 12/25/2014 10:26:07 AM
RE: Remove Stru Posted by sandeep singh @ 12/31/2014 8:49:53 AM