Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vincent Byrne
  Where is Vincent Byrne?
 Dorsten
 Germany
 Vincent Byrne
 To: rose cruz
  Where is rose cruz?
 navotas
 Philippines
 rose cruz
 Tags
Subject: RE: Change of Field size using code.
Thread ID: 228616 Message ID: 228620 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Wednesday, May 20, 2009 10:58:39 AM         
   


> Hi,
>
> Good Day...
>
> How can I change 1 of the column field type numeric size of a table without using modify structure and using code only.
>
> Example:
>
> branch n(3,0) to branch n(4,0)
>
>
> Thanks and Godbles...

Hello Rose

look in the help file from VFP and you will find this.

ALTER TABLE TableName1 ADD | ALTER [COLUMN] FieldName1 

      FieldType [( nFieldWidth [, nPrecision])] 


in your case you would write

Alter Table yourTableName Alter Column Branch n(4,0)


By the way please DON'T post your threads more than once, it clutters up the forum!!!


Best Regards

Vince

ENTIRE THREAD

Change of Field size using code. Posted by rose cruz @ 5/20/2009 10:51:41 AM
RE: Change of Field size using code. Posted by Vincent Byrne @ 5/20/2009 10:58:39 AM
RE: Change of Field size using code. Posted by Anders Altberg @ 5/20/2009 10:59:37 AM
RE: Change of Field size using code. Posted by Borislav Borissov @ 5/20/2009 10:59:44 AM