Look up the EVALUATE function in VFP help. Basically:
If eval("A."+CField) != eval("B."+CField)



>I have a program in which I need to compare certain fields from two tables to determine if there are any changes in the values.
>
>I have put the field names that I need to check to an array and seek both tables for matching records (by sin). Then I scan through my array which contains each field name (using a for loop). I then try to assign each alias name to the field name to compare. The field name is a variable for the current array element, and I am not sure how to reference the alias name to that variable.
>
>My code is similar to this.
>
>Select A
>Select B
>
>******Seek the sin I want in both tables and when found...****
>
>x=0
>For x= 1 to Alen(Afieldnames)
> CField = Allt(Afieldnames[x])
> If "A."+CField != "B."+CField
> Replace "A."+CField with "B."+CField
> Endif
>Next
>
>It is picking each field up as a string and always gets inside the If because the values aren't equal and then replaces the field with "A.FIRSTNAME" if that is the field element it is currently on.
>
>I need to know how the syntax on how to check the field values (A.Firstname, etc...)
>
>Any suggestions would be great.
>
>Jolene Dicks