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 purpose of employees table in ps?

484


What is search/match?

512


How is geographic location code different from locations?

493


How is standard hour and fte auto calculated when entering job details for a new hire?

493


In which scenarios can a person hold multiple jobs?

558






What is the purpose of personal data refresh process?

494


How is standard hour and fte auto calculated?

533


What are security sets and security access types?

469


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

460


What is future-dated security?

500


How peoplesoft hrms stores data?

480


What is the purpose of employees table in ps? How is this table populated?

478


What are transaction tables in peoplesoft hrms?

556


What are prompt tables in peoplesoft hrms?

480


How do you modify security trees?

497