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 are the parameters that are used for running the sqr from command prompt?
What is the difference between search box search and search/match?
Explain the difference between transaction table and setup tables?
What is peoplesoft enterprise hrms integrations?
How do you allow workers to update their own data?
How is geographic location code different from locations?
explain about hr business transactions?
What are checklists?
What is person or position structure in peoplesoft hrms?
What is search/match?
What are prompt tables in peoplesoft hrms?
What are business units in peoplesoft hrms?
When you access an hcm component, say, job data, certain values like business unit, company etc are defaulted. What governs this concept?
How do you setup person of interest types?
What are checklists? Give an example from the delivered checklists. How will you create a checklist of your own? Explain by giving an example?