Field data transfer within the same table

sjen

How can copy data from one field to another field in the same table? Let's say I have a test table and two fields in it.
field ID 50000 "no-old" which has data
field ID 50001 "no" has no data.
I want to copy data in "no-old" to "no" field.

I am writing a report to copy a field from one to another and I thought one single line would do the trick but it doesn't copy anything.

OnAfterGetRecord()
no := "no-old";

Thank you

TallyHo

MyTable.FINDSET;
REPEAT
MyTable."No" := MyTable."No-old";
MyTable.MODIFY;
UNTIL MyTable.NEXT <= 0;

TallyHo

MyTable.FINDSET;
REPEAT
MyTable."No" := MyTable."No-old";
MyTable.MODIFY;
UNTIL MyTable.NEXT <= 0;

sjen

Thank you TallyHo!! I thought I wouldn't need findset since it has only one record plus I forgot to add modify. Thank for your time