>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?
Whan you want to replace something in OTHER table than the current alias ALWAYS use IN clause
...
REPLACE ALL OtherField WITH 1 IN DataEntry
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.