Skipping rows in rosters
Posted: July 28th, 2021, 4:51 am
Hi All,
I have this query of implementing skips on rows of a roster. Kindly help me achieve this scenario.
For instance, I have a roster NAME_OF_THE_HOSPITAL000. It has 5 rows and one of it's column field is SPEC.
The validation for these fields are such:
(1) if SPEC value is 1 for any row, let's say Row1, it skips to next row, that is Row2.
(2) if SPEC value is 2 for Row3 particularly, it skips to next to next row, that is Row5.
My code is as such:
On entering value 1 in Row 5, it works fine and skips to next row.
However, I'm getting error on entering value 2 in Row5, that is: "Unable to skip, target item is the current item"
I have this query of implementing skips on rows of a roster. Kindly help me achieve this scenario.
For instance, I have a roster NAME_OF_THE_HOSPITAL000. It has 5 rows and one of it's column field is SPEC.
The validation for these fields are such:
(1) if SPEC value is 1 for any row, let's say Row1, it skips to next row, that is Row2.
(2) if SPEC value is 2 for Row3 particularly, it skips to next to next row, that is Row5.
My code is as such:
Code: Select all
PROC SPEC
if SPEC = 1 then skip to next;
endif;
if SPEC(3) = 2 then skip to SPEC(5);
endif;
However, I'm getting error on entering value 2 in Row5, that is: "Unable to skip, target item is the current item"
!