>>I coded a program in vfp50. Now, after the program was distributed,
>>The customer wants me to change one of the fields in one of the tables. The field he wants to change is:
>>Num decimal
>>3 2
>>
>>to this
>>Num decimal
>>3 3
>>
>>The customer does not wants to loose any data and he wants to be able
>>to transfer data from the old number fld to the new one.
>>I have to do this using program code....Any ideas?
>
>Alter table mytable alter column myfield N(3,3)
Actually if you need 3 decimal places, then you need a field width of 4. One is needed to hold the decimal point.
Alter table mytable alter column myfield N(4,3)
kenweber
GCom2 Solutions
Microsoft Certified Professional