>>>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)
>
>... see VFP Help on ALTER TABLE - SQL for all the details.
----------
hey Mark and Ken ... thanks for your answers...