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

How do you modify security trees?

506


What’s the difference between person or position?

474


What is the difference between transaction table and setup tables?

502


What are the parameters that are used for running the sqr from command prompt?

472


What is regulatory region?

514






Explain the use the concept of effective sequence

476


What are tablesets and setids in peoplesoft hrms?

453


What is person or position structure in peoplesoft hrms?

480


What is job family? How is it different from job codes in ps?

489


How to retrieve the data from 3rd scroll, using traversing?

467


What are the different components and component interfaces in peoplesoft hrms?

470


What are the possible hr business tractions that can follow post termination action row for an employee in job data?

495


How peoplesoft hrms stores data?

487


Different steps in workforce administration in hiring?

472


When do we use the concept of effective sequence?

517