>I have to work with a file that has 164 fields. I know: it needs normalization, but this is the government - we don't have time for efficiency!
>
>Is there an easy way to compare two records within the same file? I'd like to just say something like "IF Rec#1 = Rec#2 Do Something" - is this possible?
>
>Or will I have to compare them one field at a time?
>
>Thanks!
>
>\/\/\
You would need a comparing function then.
function IsSame
parameters tcTable, tnRec1, tnRec2
select * from (tcTable) ;
where recno() = tnRec1 ;
union ;
select * from (tcTable) ;
where recno() = tnRec2 ;
into array myArray
return iif(alen(myArray,1) = 1, .T., .F.)
Cetin