Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 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: 228624 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Wednesday, May 20, 2009 10:59:44 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...


TRY
   USE TableName EXCLUSIVE
   ALTER TABLE TableName ALTER COLUMN Branch N(4)
CATCH
ENDTRY


-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

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