recordset.field

Description

The field property of the recordset object type is used to retrieve the value of a field of the current record in the current recordset. The isnull function can be used to test if the value of the field is NULL. NOTE: field is a read-only property of type variant.

Currently, this property is read-only so you can not use it to change the contents of the record fields (i.e. you can't use this property to change the database). If you want to change the database call the execute method of the connection object type and pass in a SQL UPDATE statement.

Example

For example, if you have a recordset object reference rs with an open recordset and the records in the recordset have a field named last_name then

   rs.field('last_name')

constains the contents of the field last_name for the current record in the recordset.

NOTE: Since this property is used so often, you can leave out the name of the property (i.e. field). So for example

   rs.('last_name')

is equivalent to

   rs.field('last_name')

Portability

Operating Systems: All
Standard Pascal: No