An array that contains the Field objects in a rowset.

Property of

Rowset, TableDef


The fields property contains an object reference to the array of field objects in the rowset. These fields can be accessed by their field name or their ordinal position; for example, if this refers to a rowset:

this.fields[ "State" ].value = "CA" // Assign "CA" to State field

this.fields[ 1 ].value = 12 // Assign 12 to first field

To access the value of the field, you must reference the field’s value property. You can use the add( ) method to add new Field objects to the fields array as calculated fields.