Using the Fill Method

The Fill method fills the rowset by reading records from the database, by first flushing out all the contents of the rowset. A Where clause must be provided to get all the relevant rows.

Local Rowset &MYRS; 
Local String &EMPLID; 
&MYRS = CreateRowset(RECORD.SOMEREC); 
&EMPLID = '8001'; 
&MYRS.Fill("where EMPLID = :1", &EMPLID); 
 

Use the Fill method with standalone rowsets, created using the CreateRowset function. Do not use Fill with component buffer rowsets.