I would expect the command

REPLACE myTable.value1 with nTestVal

to execute without a problem, assuming

myTable is open and active,
and the source and destintation are of comparable types.

Yet I see cases from time to time where it doesn't work when the source is numeric and the destination is currency. No error message - just no data move. I've solved the issue with ugly work-arounds moving the data to differnety types, which surely is not necessary.

Are there other gottchas (pitfalls) that may be causing the replace to not function.

Thanks,

Dennis