>It seems to me that in FoxPro Dos that if multiple tables were open that it was possible to do replace commands on tables other than the currently selected tables with the syntax "Replace sometable.somevalue with newvalue" and it would work without any problem. In VFP I have traced over code where the replace command using this syntax was basically ignored. However, if I wrote "replace somevalue with newvalue in sometable" it would work. Is there a difference between the way the these two commands work? Since I am in the process of updating several DOS programs to VFP this is important to me in the amount of rewriting I need to do. Thanks!
I am not sure how different they are. However, I do know that if you use
REPLACE table.field WITH value and there is no currently selected alias VFP will generate an error. In general, you should use syntax with the "IN" clause to make sure it will work as expected.
Hector Correa