I am having following code in my program :-

tmpfldname="main.code"
tmpfilename="main"

When I issue the below written sql command :-

select distinct eval(tmpfldname) from (tmpfilename) into array test

It returns me 124 records (which is correct),
But if I issue this same command again, It gives me only one record.

Whereas, If i issue the below written command any no. of times, It always returns me 124 records

select distinct &tmpfldname from (tmpfilename) into array test

I don't understand why macro is working and eval is not or am I doing anything wrong. Pls advs.