UpdateAll Method

Object List Next Object

Defined By: Dynaset

Description:

Saves all unsaved changes in the underlying database to the source database.

Declaration:

Sub UpdateAll ()

Details:

If the underlying database is an ODBC relational data source, the UpdateAll method will save all changes to the underlying database object back to the actual relational database source.

If the underlying database is an OCBC ASCII text file, changes cannot be made to the underlying database, therefore, the UpdateAll method will not peform its normal function.

If the underlying database is a FixedAscii or DelimitedAscii text file, the UpdateAll method saves the entire contents of the underlying database to the source ASCII text file.

The following example reverses the company names on the first two rows of the underlying database and updates both changes to its data source file.

Debug.Print Form1.<Dynaset>.Row(0).Column(0).Value
CIMLINC Itasca
Debug.Print Form1.<Dynaset>.Row(1).Column(0).Value
CIMLINC Troy

Form1.<Dynaset>.Row(0).Column(0).Modify("CIMLINC Troy")
Form1.<Dynaset>.Row(1).Column(0).Modify("CIMLINC Itasca")
Form1.<Dynaset>.UpdateAll

See Also:

Update method