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