thank you for reply,
i try without ALTER TABLE (TT) ADD COLUMN TXPNO C(19) && it works
but still i need to add this fields via internal vfp code
>Fire VFP debugger and check values of m.OldName and m.NewName at the time of error
>
>>
>>i try this code before it works, i try it again i get error message syntax error
>>
>>
>> ALTER TABLE (tt) RENAME COLUMN (m.OldName) TO (m.NewName)
>>next
>>