Microsoft ActiveX Data ObjectsMicrosoft ActiveX Data Objects*
*Contents  *Index  *Topic Contents

Clear Method - ADO

Removes all of the objects in a collection.

Applies To

Errors

Syntax

Errors.Clear

Remarks

Use the Clear method on the Errors collection to remove all existing Error objects from the collection. When an error occurs, ADO automatically clears the Errors collection and fills it with Error objects based on the new error. However, some properties and methods return warnings that appear as Error objects in the Errors collection but do not halt a program's execution. Before you call the Resync, UpdateBatch, or CancelBatch methods on a Recordset object or before you set the Filter property on a Recordset object, call the Clear method on the Errors collection. Doing so enables you to read the Count property of the Errors collection to test for returned warnings as a result of these specific calls.

Examples

Execute, Requery, and Clear Method Example (VB)


Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.