FIX: Spelling Error in ADO Type Library - Schema Constraint (190201)
The information in this article applies to:
- ActiveX Data Objects (ADO) 1.5
- ActiveX Data Objects (ADO) 2.0
- ActiveX Data Objects (ADO) 2.1
This article was previously published under Q190201 SYMPTOMS
The constant adSchemaReferentialConstraints is a parameter that you can
pass to the OpenSchema method. In the type library it appears as
adSchemaReferentialContraints. Notice the "s" is missing in "Contraints".
The constant is correctly spelled "adSchemaReferentialConstraints" in the
documentation.
CAUSE
The constant is misspelled in the type library.
RESOLUTION
The spelling of the constant has been fixed in MDAC 2.1 and later.
Visual Basic users are fortunate since the help of IntelliSense selects the
constraint without checking the spelling of the constant.
VBScript users must misspell the constant in code (that is,
adSchemaReferentialContraints) or use the numeric value 9.
For example:
Set rs = OpenSchema( 9, criteriaArray)
Set rs = OpenSchema(adSchemaReferentialContraints,criteriaArray)
STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed
at the beginning of this article. This problem has been corrected in MDAC 2.1.
MORE INFORMATION
The constant adSchemaReferentialConstraints is spelled correctly in the Microsoft Developer Network (MSDN) and Data Access Software Development Kit (SDK) documentation.
REFERENCES
For additional information about ADO OpenSchema Method, please see the following article in the Microsoft Knowledge Base:
186246 HOWTO: Use the ADO OpenSchema Method in Visual Basic
| Modification Type: | Minor | Last Reviewed: | 3/2/2005 |
|---|
| Keywords: | kbADO210fix kbBug kbDatabase kbDSupport kbMDACNoSweep kbNoUpdate KB190201 |
|---|
|