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
How is geographic location code different from locations?
How is standard hour and fte auto calculated when entering job details for a new hire?
What is job family?
What is the purpose of personal data refresh process?
How do you setup search/match?
What are the different components and component interfaces in peoplesoft hrms?
What are tablesets and setids in peoplesoft hrms?
How peoplesoft hrms stores data?
What is the difference between search box search and search/match?
When you access an hcm component, say, job data, certain values like business unit, company etc are defaulted. What governs this concept?
What are checklists? Give an example from the delivered checklists. How will you create a checklist of your own? Explain by giving an example?
How to access an hcm component?
What are tablesets and how do you work with them?
What are transaction tables in peoplesoft hrms?
What are global assignments?