BUG: Spelling Error in ADO Type Library - Schema Constraint

ID: Q190201

The information in this article applies to:

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

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.


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:

Q186246 Use the ADO OpenSchema Method in Visual Basic

Additional query words: 


Keywords          : kbADO kbADO150bug kbADO200bug kbSweepNext 
Version           : WINDOWS:1.5,2.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 19, 1999