First the most important step is to fix the corrupted table. If you would be able to do this, then there would be no problem changing the structure.
>thank you for reply,
>i try it , but still i need to make modi stru for some fields as change from n(7) to n(4),
>
>as use trans1
>modi stru
>
If it's not broken, fix it until it is.
My Blog