Scripted Find using ≠ doesn't work

[ken_s2007]

I imagine this is FM101, but here goes. The following scripted find works if I use "=" (but with different effect, of course), but when I use "≠", I get unexpected results (I get records with two fields that both are equal and not equal.)

Doesn't work as expected (I'm trying to end up with a found set of records where the value of two fields match):

fieldA and fieldB are number fields.

Perform Find [Restore] [Find all records with a non-null value for fieldA - this step works]

Go to Record… [First]

Loop

If [table::fieldA ≠ table::fieldB]

Omit Record

End if

Got to Record… [Next; Exit after last]

End Loop

Thanks, Ken

Edited November 16, 2009 by Guest

[Vaughan]

Finds don't work that way, because it would require the find request to be different for each record. It's essentially putting dynamic criteria that depends on each individual record.

Create a calculation field with the expression fieldA = fieldB. Th result of the expression will be either 1 or 0. Now perform the find in the calc field for zero.