Clear Method

The Clear method on a Collection object removes all of the objects in a collection.

collection.Clear
 

Parameters

None.

Remarks

The Clear method is used 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 calling the Resync, UpdateBatch, or CancelBatch methods on a Recordset object or before setting 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.