I have a cursor named crsfinal with one field called mainkey. I have another table named modacad with the same field named mainkey and additional fields. I would like to input a value called "Changed" into a field called moc023 in modacad if the mainkey is present in crsfinal and modacad. I have tried:

SCAN
select modacad
REPLACE moc023 WITH "Changed" FOR crsfinal.mainkey=modacad.mainkey
ENDSCAN

This does not do anything. Can anybody put me in the right direction.

Many Thanks