Read Data From Table or Views into a Rowset Object

Your rating: None Average: 1.5 (2 votes)

Grids are used all the time in PeopleSoft, and to populate them with
dynamic data could be quite challenging. Use the "Select" function to
read data from the database tables or views into either a row or rowset
object.

The following example first flushes the hidden work
scroll, then selects into it based on a field on the page, or any
criteria that you add to the “where clause”.

&RS = GetLevel0()(1).GetRowset(Scroll.CHECKLIST_ITEM);
&RS.Flush();
&RS.Select(RECORD.CHECKLIST_ITEM, "where Checklist_CD = :1 and
EffDt = (Select Max(EffDt) from PS_CHECKLIST_ITEM Where CheckList_CD =
:2)", CHECKLIST_CD, CHECKLIST_CD);

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
SHPRAK's picture
User offline. Last seen 10 years 31 weeks ago. Offline
Joined: 01/06/2009
Posts: 1
Re: Read Data From Table or Views into a Rowset Object

Hi All,

I am new to peoplesoft and want to know that how wecan read
data from record to a file.

Regards
S.P

Srinivas345's picture
Srinivas345 (not verified)
Re: Read Data From Table or Views into a Rowset Object

do u mean to read a record with rowset concept?