Hello,
Your code is not clear, I do not have your table architecture so I am giving you some suggestions.
GET is working on primary Key.
If you need to update all the records then use below format, it would be more faster than you written.
IF Status=Status::Released THEN BEGIN
FixedAsset.RESET;
//Also use filter here based on relation between fixedAsset and Your table
//You can remove the Repeat until if single record needs to update.
IF FixedAsset.FINDSET THEN
REPEAT
//Your Statement, for example
IF Customer.GET('10000') THEN BEGIN
Customer.Address := 'New Address 12345';
Customer.Modify();
END;
UNTIL FixedAsset.NEXT = 0;
END;
What is the primary Key fields of Reco?
Repeat Until is used for get/update set of records based on filter criteria and you have mentioned you want only last record.
rewrite your code by filtering the Fixed Asset records as shown below.
Still if you have doubt then share your Tables fields with relations and some data so that I can check and update.
IF Status=Status::Released THEN BEGIN
FixedAsset.RESET;
FixedAsset.SETRANGE(LinkField, LinkedValue);
IF FixedAsset.FINDLAST THEN BEGIN
//Your Statement for example
FixedAsset."FA Status" := "FA Status";
FixedAsset.Modify();
END;
END;
