Modify Method

Object List Next Object

Defined By: Dynaset

Description:

Sets or changes the value of the specific field.

Declaration:

Sub Modify (ByVal s As String)

Details:

Using the Row/Column syntax, Modify may be used to alter the value contained at the specified row and column. If the specific cell is being held in an object or object reference, the Object syntax may be used. For example, the following statements will change the contents of the "Name" field in the corresponding record.

<Dynaset>.CurrentRecord.Fields("Name").Modify("Stephen Burns")
<Dynaset>.Row(0).Column(0).Modify("Stephen Burns")

If the underlying database is an ODBC ASCII text file, the Modify method can not be used to make changes to the data. Currently, the ODBC text driver does not support any saving of data to ASCII textfiles.