Problem modifying table data

Thanks for your answer.

But I tried that too. I rechecked it and sadly it does not work.

Karsten.

Maybe I'm doing something fundamentally wrong:

Task:
Create a report with a single data item and a request form which lets you choose a new value to replace a field value in a table.

What I did.
1.I created a report which shows some values from this table including the location code which should be replaced with a new one.
This table contains production components for a manufacturing order.Which are take from a specific location code value.
The location code is outdated.
The report shows the information of the table production components correctly according to the filters set in the report view.
2. I attached a request form to the report which links to the table "location code" and returns the chosen new location code as a variant "new_location_code" (source expression)
3. I included a field for new_location_code in the report to check if the chosen location from the request form is correctly retrieved.
And that also works. The report displays the old location code from the table production components and the "new_location_code" I want to use from the request field.
4. Now I actually want to replace the old location code with the new_location code and write that back to the table.
5. I created a record variable of the table component line.
And inserted the following code to the onaftergetrecord trigger:

component_line_rec.INIT;
component_line_rec.SETRANGE(Status);
//MESSAGE('%1',"Prod. Order No.");
order_line_rec.SETRANGE("Prod. Order No.");
IF component_line_rec.FIND('-') THEN BEGIN
MESSAGE('correct');
//component_line_rec.VALIDATE("Location Code",New_Location_Code);
component_line_rec."Location Code":=New_Location_Code;
//order_line_rec.MODIFY;
MODIFY;
MESSAGE('%1 , %2',component_line_rec."Location Code", New_Location_Code);
end;

Everything is displayed in the final Message as it should be.
component_line_rec."location code" is the same as new_location_code.
But somehow the modify does not write the new value for location code in the table production component.

I'm rather puzzled about that behavior.

Greeting,
Karsten.

Isn't rename for changing primary keys and not for changing normal data fields. Location code is no primary key in this table. Although it is used in some secondary keys.

Karsten.

OK,
I did that from scratch and now it works as expected.

Probably I seriously need some vacation.

Thanks for your help.

Karsten.