How To Respond to the Auto-commit Feature of a VB Data Control (172381)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition for Windows 5.0
- Microsoft Visual Basic Professional Edition for Windows 6.0
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft Visual Basic Standard Edition, 32-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
This article was previously published under Q172381 SUMMARY
When you perform any of the following actions on a Visual Basic Data
Control, any changes to controls bound to the Data Control are
automatically committed to the Database:
- Move off the current record with any of the Move methods (MoveFirst,
MovePrevious, MoveNext, MoveLast, or Move).
- Move off the current record using the VCR-like buttons of the Data
Control.
- Add a new record with the AddNew method.
- Update a record that is being edited or added with the Update method.
Note that this is not the UpdateRecord method.
- Delete the current record with the Delete method.
- Move off the current record with any of the Find methods (FindFirst,
FindNext, FindPrevious, FindLast, or Seek). This only applies to the
Table-type RecordSet object.
- Move off the current record by setting the Bookmark property.
- Close the RecordSet with the Close method.
- Unload the form that the data control is on.
This article shows how to use the Action parameter of the Data Control's
Validate event to respond to this automatic commit.
Modification Type: | Minor | Last Reviewed: | 7/15/2004 |
---|
Keywords: | kbhowto KB172381 |
---|
|