The DJRowSet object is container for storing collections of record instances. A single DJRowSet object can store many different types of records. DJRowSet is both more flexible and more convenient for storing record images than arrays. Unlike arrays, each row in a row set can have a different number of elements. In effect, the row set is like a jagged array. Another advantage of row sets over arrays is that row sets have operations for inserting, appending, and deleting rows. With arrays, these operations require user-defined code.

 

The FieldCount property returns an integer value with the number of fields in specified row of the row set.

 

The FieldCount method may return the following exceptions if there is an error at run time:

The Self property is used for getting a reference to an object that can then be passed as an argument to a function or method call. The reason for having a special property for getting the object reference is to resolve an ambiguity with the default property, Value. This is similar to the distinction between normal variable assignment (Let) the use of Set for assigning object variables. When a DJRowSet object variable is used without an associated property or method, the integration language processor assumes an implied access of the Value property.

 

The following example shows how the Self property might be used when copying data from a row set to a record.

The Size property is used to determine how many rows are stored in a DJRowSet container.

 

Get or set the record type name for a row in a row set. The DJRowSet can contain record images for many different types of records. The TypeName property is used to identify type of each record.

 

The TypeName method may return the following exceptions if there is an error at run time:

Get or set the field value for a field in a row stored in a row set.

 

The Value method may return the following exceptions if there is an error at run time:

 

The Append method adds a new row to a row set. The new row is created using a list of values or by copying values from a DJRecord object.

 

The Append method may return the following exceptions if there is an error at run time.

The Clear method removes all rows from a row set.

 

The Erase method is used to erase a row from a row set. The row is specified using the rownum parameter.

 

The Erase method may return the following exceptions if there is an error at run time:

The Insert method inserts a new row in a row set. The row is inserted in the row set at the position specified by the rownum parameter. If a row with that index already exists, it is moved further down in the row set and can be indexed with rownum + 1. Rows can be inserted with index values of 1 to rowset.Size + 1. The new row is created using a list of values or by copying values from a DJRecord object.

 

The Insert method may return the following exceptions if there is an error at run time:

 

The New operator creates a new instance of a DJRowSet object. The operator returns a reference to the new object. Typically, this reference is assigned to an object variable that has been declared with a compatible type. The assignment is done using the Set statement.