GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PS Mixed
Go To First  |  Previous Question  |  Next Question 
 PS Mixed  |  Question 10 of 200    Print  
How do you retrieve a value from scroll..scroll select?

  
Total Answers and Comments: 12 Last Update: February 04, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: L.Ramesh
 

consider you are at level 0 and you want to fetch a field from level 2 row you can use the following syntax

The syntax is

&field=getrowset(scroll.level1 rec name)(1).GetRowset(Scroll.level2 rec name)(level 2 row number).Level2 Rec Name.Field Name



Above answer was rated as good by the following members:
suresh33.a
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
July 21, 2005 09:12:07   #1  
oraclef        

RE: How do you retrieve a value from scroll..scroll select?
getLevel0().get(1).getRowSet( record name of the record assosiated with scroll record ).

I am not sure about this but it looks something like this I am just giving you guys an idea. Don't take this for granted as I have not tested it.

 
Is this answer useful? Yes | No
August 30, 2005 00:49:04   #2  
satya        

RE: How do you retrieve a value from scroll..scroll select?
&var GetLevel0()(1).GetRowset(Scroll.);

&var1 &var.GetRow(1).GetRowset(Scroll.);

 
Is this answer useful? Yes | No
September 07, 2005 10:22:58   #3  
amseen        

RE: How do you retrieve a value from scroll..scroll select?
&Lev0_rowset GetLevel0()(1);
&Lev1_rowset &Lev0_rowset.getrowset(scroll.);
for &I 1 to &Lev1_roset.activerowcount
&rec .....;
&fld ....;
end-for;

 
Is this answer useful? Yes | No
November 17, 2005 20:03:54   #4  
Raji        

RE: How do you retrieve a value from scroll..scroll se...

&L0 GetLevel0();

&Row0 &L0.GetRow(1);

&RowSet &Row0.GetRowSet(Scroll.RECORDNAME);

For &i 1 to &RowSet.ActiveRowCount

&Row1 &RowSet.GetRow(&i);

&Rec1 &Row1.GetRecord(RECORD.RECORDNAME);

For &f1 1 to &Rec1.FieldCount

&FIELD1 &Rec1.GetField(&F1);

end-for;

end-for;


 
Is this answer useful? Yes | No
January 02, 2006 05:35:46   #5  
L.Ramesh        

RE: How do you retrieve a value from scroll..scroll se...

consider you are at level 0 and you want to fetch a field from level 2 row you can use the following syntax

The syntax is

&field getrowset(scroll.level1 rec name)(1).GetRowset(Scroll.level2 rec name)(level 2 row number).Level2 Rec Name.Field Name


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
January 02, 2006 06:09:33   #6  
ramesh_psoft Member Since: January 2006   Contribution: 1    

RE: How do you retrieve a value from scroll..scroll se...

consider u are at level 0 and u want to fetch a field from level 2 scroll

You can use the following syntax

&field GetRowset(scroll.level 1 RecName)(Lev 1 Row#).GetRowset(Scroll.Level 2 RecName)(Lev 2 Row #).RecNmame.FieldName

or

Local RowSet &RS1;

Local RowSet &RS2;

Local Field &Field;

&RS1 GetRowset(scroll.level 1 RecName);

for &I 1 to ActiveRowCount(&RS1);

Row1 &RS1(&I);

&RS2 Row1.GetRowset(Scroll.Level 2 RecName);

for &J 1 to ActiveRowCount(&RS2);

&Field &RS2.Level2 Rec Name.Field Name;

Do required operations with the field value

.....

.....

End-for;

End-for;


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
January 05, 2006 02:17:30   #7  
praveen        

RE: How do you retrieve a value from scroll..scroll se...
&var GetLevel0()(1).GetRowset(Scroll.Recordnme);

 
Is this answer useful? Yes | No
May 10, 2006 00:44:35   #8  
Prashans        

RE: How do you retrieve a value from scroll..scroll se...

If u want to fetch the filed value from the 2nd level then the following code will help u.


/*getting the scroll level 0's first row*/

&rs0 GetLevel0();
&row0 &rs0.GetRow(1);

/*getting the scroll level 1's first row*/

&rs1 &row0.GetRowset(1);
/*&row1 &rs1.GetRow(1);

/*getting the scroll level 2's first row*/

&rs2 &row1.GetRowset(1);
&row2 &rs2.GetRow(1);

/*getting the scroll level 2's first row's first record and its 4th field's value*/

&rd1 &row2.GetRecord(Record.RecName);
&rf4 &rd1.GetField(Field.FieldName);


 
Is this answer useful? Yes | No
June 06, 2006 23:52:34   #9  
kinker        

RE: How do you retrieve a value from scroll..scroll se...
Guys u have helped us a lots!May god bless u.
 
Is this answer useful? Yes | No
June 13, 2006 02:01:46   #10  
vinaykanth        

RE: How do you retrieve a value from scroll..scroll se...

getlevel(0).getrecord1.recname.getrecord2.recname.gettargetrecord.recname(get strg).get(turbo).


 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape