ASP constant table (1)

The following constants are pre-defined by ADO. For scripting languages, these constants are contained in adovbs. inc or adojava. inc. These files are stored in the programFilesCommonFilessystemado directory. For ASP, you can include these files or use a METADATA tag to reference the Type Library. <! -- METADATATYPE = "typelib" unid = "{00000205-0000-0010-8000-00AA006D2EA4}" --> you can include this METADATA mark on a separate ASP page or in global. asa. For Visual Basic, these constants are automatically included when the ADO Library is referenced.
1. AffectEnum constant
The name, value, and description of the AffectEnum constant are shown in the table F-1.
Table F-1AffectEnum constant name, value, and description
Name value description
The adAffectAll3 operation affects all records in the record set.
The adAffectAllChapters4 operation affects all sub-(unit) records.
The adAffectCurrent1 operation only affects the current record.
The adAffectGroup2 operation only affects records that meet the current Filter attribute.
2. BookmarkEnum constant
The name, value, and description of the BookmarkEnum constant are shown in the table F-2.
Table F-2BookmarkEnum constant name, value, and description
Name value description
AdBookmarkCurrent0 by default, starting from the current record
AdBookmarkFirst1 starts from the first record
AdBoodmarkLast2 starts from the last record
3. CEResyncEnum constant
The name, value, and description of the CEResyncEnum constant are shown in the table F-3.
Table F-3CESesyncEnum constant name, value, and description
Name value description
AdResyncAll15: synchronize the data of each unfinished row.
AdResyncAutoIncrement1 and then synchronize the auto-added values of all successfully inserted rows. The default value is
Appendix FADO2.5 constant count 903
Download
(Continued)
Name value description
AdResyncConfiicts2 then synchronizes all rows that fail to be deleted or updated due to parallel operation conflicts.
AdResyncInserts8: synchronize all successfully inserted rows, including the value of the column
AdResyncNone0 is not executed before synchronization
AdResyncUpdates4: synchronize all successfully updated rows.
4. CommandTypeEnum constant
The names, values, and descriptions of CommandTypeEnum constants are shown in the table F-4.
Table F-4CommandTypeEnum constant name, value, and description
Name value description
Ad1_file256 indicates that the provider should assign a value to CommandText as a previous permanent file
AdCmdStoredProc4 indicates that the provider should assign a value to CommandText as a stored procedure.
AdCmdTable2 indicates that the provider should generate an SQL query to return the table specified in CommandText.
All rows in
AdCmdTableDirect512 indicates that the provider should return all rows in the table specified in CommandText
Adc0000text1 indicates that the provider should assign a value to CommandText using a written command definition (like an SQL statement).