How to retrive the data from 3rd scroll, using traversing.
any one can help with the clear syntax
- 4 Answers
- 24138 Views
- Amtex, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / devipriya
getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(1).
getrecord(record.level3record);
| Is This Answer Correct ? | 14 Yes | 8 No |
Answer / alekhya
getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(3).
getrecord(record.level3record);
The above answer is for to retrieve the 3rd scroll recoed
level data only.
If u want the field level information use below syntax
getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(3).
getrecord(record.level3record)getfield(field.fieldname);
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / venkatesh
&LEVEL0 = GetLevel0();
&LEVEL0_ROW = &LEVEL0(1);
&LEVEL1 = &LEVEL0_ROW.GetRowset(SCROLL. STDNT_CAREER); /*it will loop every career*/
For &I = 1 to &LEVEL1.ActiveRowCount
&LEVEL1_ROW = &LEVEL1(&I);
&LEVEL2 = &LEVEL1_ROW.GetRowset(SCROLL. STDNT_ACAD_PROG);
For &J = 1 to &LEVEL2.ActiveRowCount /*it will loop every program under career*/
&LEVEL2_ROW = &LEVEL2(&J);
&RECORD = &LEVEL2_ROW. STDNT_ACAD_PROG;
&FIELD = &RECORD.Descr;
| Is This Answer Correct ? | 1 Yes | 0 No |
What are tablesets and how do you work with them?
What is a control table in peoplesoft hrms?
pl. help me, i want people soft HRMS training institute, in chennai
What is search/match?
What are effective dates and what are the benefits of it?
What are business units in peoplesoft hrms?
Explain the Usage of regulatory region?
Explain the difference between transaction table and setup tables?
explain about hr business transactions?
Which method should you use person or position?
What is the purpose of personal data refresh process?
What are the parameters that are used for running the sqr from command prompt?
PeopleSoft HRMS 
