>For the replace I am doing, I am changing the bay of the record. But bay is part of the primary key. Could this be why the first record is being updated, but the other records are not being updated? Could vfp's optimization causing this problem?
>
Hi Jason,
No, it's not Rushmore optimization. However, if you have index order set to any key that is updated by REPLACE command, than it would cause such result.
--sb--