Standalone Rowset

In PeopleCode a standalone rowset is an independent rowset object not associated with the component buffer. They allow you to work with data outside of the buffer by getting whatever additional data you need form the database. In this sense they replace the functionality of derived records which were once used as place holders to store data not directly associated with the component.

Because a standalone rowset is standalone, there is no automatic action by the component processor on it. This means that if a standalone rowset is used to manipulate data (inserts/updates), code will need to be added to manually save the changes.

Code to create a standalone rowset object

Local Rowset &rsExample;
&rsExample = CreateRowset(Record.REC1);

Note that at this point, the rowset is unpopulated.

Filling a standalone rowset

The Fill method in the Rowset class is used to populate the rowset. This parameters to the fill method are a Where clause and bind values.

&rExample.Fill("where FIELD1 = :1", REC2.FIELD2);
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License