syntax : replace [field] in [table]
>In a FoxPro 2.6 application, I need to replace fields by using a relation. I thought it should work, but it doesn't.
>
>
>USE Navigation
>SET FILTER TO MyField = 1
>
>USE Dataentry
>SET FILTER TO MyField = 100
>SET ORDER TO EmpNumber
>
>SELECT Navigation
>SET RELATION TO EmpNumber INTO Dataentry
>REPLACE ALL DataEntry.OtherField WITH 1
>
>
>Strange thing, it does not have any effect. Maybe I'm missing something?