Guaranteed Hits to your web site!












Learn Visual Basic 6.0


Appendix I: Visual Basic Symbolic Constants


Data Control Constants

Error Event Constants
Constant Value Description
vbDataErrContinue 0 Continue.
vbDataErrDisplay 1 (Default)


EditMode Property Constants
Constant Value Description
vbDataEditNone 0 No editing operation in progress.
vbDataEditMode 1 Edit method invoked; current record in copy buffer.
vbDataEditAdd 2 Add New method invoked; current record hasn't been saved.


Options Property Constants
Constant Value Description
vbDataDenyWrite 1 Other users can't change records in record set.
vbDataDenyRead 2 Other users can't read records in record set.
vbDataReadOnly 4 No user can change records in record set.
vbDataAppendOnly 8 New records can be added to the record set, but existing records can't be read.
vbDataInconsistent 16 Updates can apply to all fields of the record set.
vbDataConsistent 32 Updates apply only to those fields that will not affect other records in the record set.
vbDataSQLPassThrough 64 Sends an SQL statement to an ODBC database.


Validate Event Action Constants
Constant Value Description
vbDataActionCancel 0 Cancel the operation when the Sub exits.
vbDataActionMoveFirst 1 Move First method.
vbDataActionMovePrevious 2 Move Previous method.
vbDataActionMoveNext 3 Move Next method.
vbDataActionMoveLast 4 Move Last method.
vbDataActionAddNew 5 Add New method.
vbDataActionUpdate 6 Update operation (not Update Record)
vbDataActionDelete 7 Delete method.
vbDataActionFind 8 Find method.
vbDataActionBookmark 9 The Bookmark property is set.
vbDataActionClose 10 Close method.
vbDataActionUnload 11 The form is being unloaded.


Beginning-of-File Constants
Constant Value Description
vbMoveFirst 0 Move to first record.
vbBOF 1 Move to beginning of file.


End-of-File Constants
Constant Value Description
vbMoveLast 0 Move to last record.
vbEOF 1 Move to end of file.
vbAddNew 2 Add new record to end of file.


Recordset-Type Constants
Constant Value Description
vbRSTypeTable 0 Table-type record set.
vbRSTypeDynaset 1 Dynaset-type record set.
vbRSTypeSnapShot 2 Snapshot-type record set.


Pen Line


Counter Hit Counter Hit


This Homepage is special brought to you by CK Tan
Hosted by www.Geocities.ws

1