Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Arvin Mendoza
  Where is Arvin Mendoza?
 The Fort
 Philippines
 Arvin Mendoza
 To: rose cruz
  Where is rose cruz?
 navotas
 Philippines
 rose cruz
 Tags
Subject: RE: Change of Field size using code.
Thread ID: 228615 Message ID: 228632 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Microsoft Office Automation
Date: Wednesday, May 20, 2009 11:32:20 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...



Hi Rose,

This may help you....

Assuming your table is Company.DBF with fields like name C(40),branch N(3,0), etc...


Close data
USE [D:\Company] IN 0 EXCLUSIVE
ALTER table Company alter COLUMN branch numeric(4,0)


Thanks!

Regards,

Arvin P. Mendoza
0923-5568185

ENTIRE THREAD

Change of Field size using code. Posted by rose cruz @ 5/20/2009 10:51:32 AM
RE: Change of Field size using code. Posted by Arvin Mendoza @ 5/20/2009 11:32:20 AM
RE: Change of Field size using code. Posted by Arvin Mendoza @ 5/20/2009 11:32:55 AM
RE: Change of Field size using code. Posted by Ammar Hadi @ 5/20/2009 3:40:10 PM