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


Please Help Members By Posting Answers For Below Questions

What is the difference between transaction table and setup tables?

494


Explain what is the most important record in ps hrms?

453


How to run the sqr in command prompt. What are the parameters that are used for running the sqr from command prompt?

469


How do you modify security trees?

496


What’s the difference between person or position?

466






When do we use the concept of effective sequence?

507


How to create field as mandatory?

541


Explain the difference between transaction table and setup tables?

470


What are tablesets and setids in peoplesoft hrms?

436


If an organization does not fit to be position driven then what are the other options in people soft to setup the hierarchy?

464


What is the difference between traction table and setup tables?

457


Explain the use the concept of effective sequence

470


What is the difference between search box search and search/match?

452


How do you setup and assigning tree-based data permission?

460


What is your understanding of peoplesoft hrms system data regulation?

474