hello,
i try as below , 2errors message 1.alias not found, i choise my table 2.file is in use

SELECT qasem
SCAN
	FOR i=3 TO FCOUNT()
		INSERT INTO newtable (no,name, fvalue) VALUES (qasem.no,qasem.name, EVALUATE(FIELD(i,qasem)))		
	ENDFOR
	APPEND BLANK IN newtable 
ENDSCAN

>

>SELECT mytable
>SCAN
>	FOR i=3 TO FCOUNT()
>		INSERT INTO newtable (no,name, fvalue) VALUES (mytable.no,mytable.name, EVALUATE(FIELD(i,mytable)))		
>	ENDFOR
>	APPEND BLANK IN newtable 
>ENDSCAN
>

>
>>mytable have fields as
>>
>>no name f1,f2,f4,f6 to....f65&& sometimes mytable have f1 to f56 aontehr time my table have only f1,f5,f8...etc
>>1 ali 12 4 34 8
>>
>>i want new table as below if f1 ,f2,f4....found()
>>
>>no name f1
>>1 ali 12
>>.
>>.
>>empty record
>>no name f2
>>1 ali 4
>>.
>>.
>>empty record
>>
>>no name f4
>>1 ali 34
>>.
>>.
>>empty record
>>
>>no name f6
>>1 ali 8
>>.
>>.
>>empty record
>>
>>thanks again
>>.
>>thanks