How to retrive the data from 3rd scroll, using traversing.
any one can help with the clear syntax
Answer Posted / kaerthikeyan
Local Rowset &rs, &rs1,&rs2;
&rs = GetLevel0()(1).GetRowset(Scroll.record(LEVEL1));
For &i = 1 To &rs.ActiveRowCount
&rs1 = &rs(&i).GetRowset(Scroll. Record (LEVEL2));
For &j = 1 To &rs1.ActiveRowCount
&rs2=&rs1(&j).getrowset(scroll.record (LEVEL3));
For &k=1 to &rs2.activerowcount
&year = &rs2(&k). Record(LEVEL3).FieldName.Value;
WinMessage(&year);
End-For;
End-For; End-For;
Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of employees table in ps?
What is search/match?
How is geographic location code different from locations?
How is standard hour and fte auto calculated when entering job details for a new hire?
In which scenarios can a person hold multiple jobs?
What is the purpose of personal data refresh process?
How is standard hour and fte auto calculated?
What are security sets and security access types?
How do you setup and assigning tree-based data permission?
What is future-dated security?
How peoplesoft hrms stores data?
What is the purpose of employees table in ps? How is this table populated?
What are transaction tables in peoplesoft hrms?
What are prompt tables in peoplesoft hrms?
How do you modify security trees?