FetchValue & UpdateValue PoepleCode Functions

Your rating: None Average: 4.1 (8 votes)

In order to reference the value of a field within a looping statement, the FetchValue and UpdateValue build-in functions can be used.

  • FetchValue(SCROLL.record_name, target_row, [recordname.]fieldname)
  • UpdateValue(SCROLL.record_name, target_row, [recordname.]fieldname), value)

Example:

For &I = 1 To ActiveRowCount(Scroll.PSU_STU_ENROLL)
&status = FetchValue(Scroll.PSU_STU_ENROLL, &I, PSU_STU_ENROLL.ENROLL_STATUS);
If &status = "ENR" Then
UpdateValue((Scroll.PSU_STU_ENROLL, &I, PSU_STU_ENROLL.ENROLL_STATUS, "CMP");
End-If;
End-For;

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
5 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.