hi,
thank you very much. it works as rocket.
>Hi Mohammed,
>1) don't use EVAL() in REPLACE command etc, because is't very slow
>2) xfile is character memory and contain alias of table. If you want use it, you must use EVAL() or & (macro).
>
>

>REPLACE IN (xfile) ;
>   FOR &lcField.==LookUp(&xval., &lcField., &xval2.) AND
>   NOT EOF(xfileF);
>   newvalue with &xfileF..BILL_VALUE&& not works
>
>

>
>MartinJ
>
>>hi,
>>
>>any idea,
>>i try as under, but still not work
>>

>>CLOSE all
>>
>>USE alltrim(thisform.text5.value) in 0
>>USE alltrim(thisform.text6.value) in 0
>>xfileF=alltrim(thisform.text5.value)
>>  ? (xfileF)&&----->TABLE NAME IS BILL
>> lcField = alltrim(thisform.text1.value)
>>
>>xval=alltrim(thisform.text5.value)+"."+lcfield
>>
>>xfile=alltrim(thisform.text6.value)
>>
>>xval2=alltrim(thisform.text5.value)+"."+lcfield
>>
>>replace IN (xfile) ;
>>   FOR EVAL(lcField)==LookUp(&xval, EVAL(lcField), &xval2) AND NOT EOF(alltrim(thisform.text5.value));
>> newvalue with xfileF.BILL_VALUE&& not works
>> *newvalue with BILL.BILL_VALUE&& IT WORKS
>>

>>i try many times as
>>

>> newvalue with  xfileF+"."+BILL_VALUE &&&variable BIIL is not found
>> newvalue with BILL_VALUE&& BILL_VALUE "variable" is not found
>> newvalue with xfileF.BILL_VALUE&&"xfileFe" is not an object
>> newvalue with evaluate(xfileF+"." + BILL_VALUE)&&BILL_VALUE "variable" is not found
>>
>>

>>thanks.