Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrive the data from 3rd scroll, using traversing.
any one can help with the clear syntax
- 4 Answers
- 25502 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 is regulatory region?
Explain the Usage of regulatory region?
What is search/match?
What is a control table in peoplesoft hrms?
What is the difference between traction table and setup tables?
What is the purpose of employees table in ps?
What is job family?
How to create field as mandatory?
What are the different components and component interfaces in peoplesoft hrms?
What are tablesets and setids in peoplesoft hrms?
What’s the difference between person or position?
How to retrieve the data from 3rd scroll, using traversing?
PeopleSoft HRMS 
