Jay,
You now have them sorted one after another.Do something like this:
scan
scatter memvar
skip
for ix=1 to fcount()
if eval(field(m.ix)) # eval('m.'+field(m.ix))
? eval(field(m.ix)),eval('m.'+field(m.ix))
endif
endfor
endscan
Cetin
>Except...
>
>Your code identifies the records, but what I need is to identify the
fields that are different. I will basically be comparing one record in one table to one record in another table and want to get a list of the fields who's values differ.
>
>Can't believe I didn't catch that earlier...