Hi,
>>
anothr thing ,if mytable have 15 fields.
but i want just 6 field to insert to newtable . ex.. i want to restor fields 2,4,5,8,9
i must write
use newtable
append blank
replace newfld1 with name
replace newfld2 with telno
replace newfld3 with address
replace newfld4 with clint_no
replace newfld5 with .....
>>
If you can use my suggestion of using 'COPY TO' you could use the fields clause:
COPY TO NewTable NEXT 4500 FIELDS name,telno,...
HTH,Viv