>OOPS - I think I have it figured out.
Hi Grady
Is it possible for you to a) provide a description in English of the problem and b) some sample data?
>
>
>----------------------------------------------------Previous message is below------------------------------------------------------
>
>>See
http://www.berezniker.com/content/pages/visual-foxpro/string-comparison-vfp>>
>>>I am making a coding error that I cannot see. The != comparison is not being caught by the program and duplicate records are being recorded.
>>>
>>>
>>> SELECT indicators
>>> SCAN
>>> m.TheWord2 = ALLTRIM(LOWER(indicator))
>>> m.sidenote2 = action
>>> IF m.TheWord2 $ lcTEXT AND m.TheWord2 != m.TheWord1
>>> SELECT MASTER
>>> REPLACE indicator2 WITH m.sidenote2
>>> SELECT indicators
>>> REPLACE hits WITH indicator.hits + 1
>>> m.sidenote2 = ""
>>> ENDIF
>>> ENDSCAN
>>>
>>>
>>>What have I overlooked?