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. 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