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 difference between transaction table and setup tables?
Explain what is the most important record in ps hrms?
How to run the sqr in command prompt. What are the parameters that are used for running the sqr from command prompt?
How do you modify security trees?
What’s the difference between person or position?
When do we use the concept of effective sequence?
How to create field as mandatory?
Explain the difference between transaction table and setup tables?
What are tablesets and setids in peoplesoft hrms?
If an organization does not fit to be position driven then what are the other options in people soft to setup the hierarchy?
What is the difference between traction table and setup tables?
Explain the use the concept of effective sequence
What is the difference between search box search and search/match?
How do you setup and assigning tree-based data permission?
What is your understanding of peoplesoft hrms system data regulation?