>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

Dennis,
The correct syntax is:

REPLACE Value1 with nTestVal IN myTable

Your REPLACE wouldn't work if you are at the BOF() or EOF() state in your current alias.