clear-method-ado.md

title	Clear Method (ADO) | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
apitype	COM
f1_keywords	Errors::raw_Clear Errors::Clear
helpviewer_keywords	Clear method [ADO]
ms.assetid	0a61ba7a-20b8-426a-91a0-9040e7c5a98a
author	MightyPen
ms.author	genemi

Clear Method (ADO)

Removes all the Error objects from the Errors collection.

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.

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; the Open method on a Connection object; or set the Filter property on a Recordset object, call the Clear method on the Errors collection. That way, you can read the Count property of the Errors collection to test for returned warnings.

Applies To

Errors Collection (ADO)

See Also

Execute, Requery, and Clear Methods Example (VB)
Execute, Requery, and Clear Methods Example (VBScript)
Execute, Requery, and Clear Methods Example (VC++)
CancelBatch Method (ADO)
Delete Method (ADO Fields Collection)
Delete Method (ADO Parameters Collection)
Delete Method (ADO Recordset)
Filter Property
Resync Method
UpdateBatch Method