thanks for reply
still same errors, i run it as.prg

select qasem&&alias not found
SCAN
	FOR i=3 TO FCOUNT()
		INSERT INTO newtable (no,name, fvalue) VALUES (qasem.no,qasem.name, EVALUATE(FIELD(i,"qasem")))&&file is in use		
	ENDFOR
	APPEND BLANK IN newtable 

ENDSCAN

>I forgot quotes
>

>... EVALUATE(FIELD(i,"qasem"))
>

>>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
>>>

>>>