ADO Method Support Summary

The following table summarizes the ADO version 1.5 object methods that are supported by the current version of the Microsoft® OLE DB Provider for AS/400 and VSAM.

ADO object	Method	Support
Collection	Append	No
	Clear	Yes
	Delete	Yes
	Item	Yes
	Refresh	Yes

Command	CreateParameter	No
	Execute	Yes, but options must be adCmdText

Connection	BeginTrans	No
	Close	Yes
	CommitTrans	No
	Execute	Yes, but options must be adCmdText
	Open	Yes
	OpenSchema	Yes
	RollbackTrans	No

Field	AppendChunk	Yes
	GetChunk	Yes

Parameter	AppendChunk	No

Recordset	AddNew	Yes
	CancelBatch	Yes
	CancelUpdate	Yes
	Clone	Yes
	Close	Yes
	Delete	Yes
	Find	Yes
	GetRows	Yes
	Move	Yes
	MoveFirst	Yes
	MoveLast	Yes
	MoveNext	Yes
	MovePrevious	Yes
	NextRecordset	No
	Open	Yes
	Requery	Yes
	Resync	No
	Supports	Yes
	Update	Yes
	UpdateBatch	Yes

Note The Collection object is actually a special case, representing a collection of other ADO objects. These collection objects support several methods:

Append to add an object to a collection
Clear to empty all objects from a collection
Delete to remove a single object from a collection
Item to returns a specific member object of a collection by name or ordinal number
Refresh to updates the objects in a collection to reflect objects available from and specific to the OLE DB provider.