Rowsets

A Rowset represents a scroll / collection of rows. 

If a rowset is instantiated with the GetRowset method then that object represents the data on the component/page.  However if it is instantiated with the CreateRowset method then it is a standalone rowset.  Standalone rowsets allow you to work on data without it being automatically tied to the database.

Rowset objects are declared with type Rowset:

Local Rowset &MYROWSET;

The Rowset class has a number of built in methods and properties. Some of the

most common are listed below.

Methods:
GetRowset, GetRow, GetRecord, GetField
FlushRow, Flush, DeleteRow - remove data from the rowset
Fill, CopyTo, InsertRow - add data to the rowset
Sort - sort data in the rowset

Properties:
ActiveRowCount - returns number of active rows for the rowset
Level - returns level of the rowset

The basic structure of the drilling down through the rowset is shown below:

Below is an example:

Below are links to other blogs I have found very helpful learning about rowsets:

http://peoplesoftobjectoriented.blogspot.com/

http://hariprasadpeoplesoft.blogspot.com/2012/04/populating-data-into-grid.html