ADO Methods

Microsoft ActiveX Data Objects (ADO)

ADO Methods

ADO Method Summary

Method Description
AddNew Creates a new record for an updatable Recordset object.
Append Appends an object to a collection. If the collection is Fields, a new Field object may be created before it is appended to the collection.
AppendChunk Appends data to a large text or binary data Field, or to a Parameter object.
BeginTrans, CommitTrans, and RollbackTrans Manages transaction processing within a Connection object as follows:

BeginTrans — Begins a new transaction.
CommitTrans — Saves any changes and ends the current transaction. It may also start a new transaction.
RollbackTrans — Cancels any changes and ends the current transaction. It may also start a new transaction.

Cancel (ADO) Cancels execution of a pending, asynchronous method call.
Cancel (RDS) Cancels execution of a pending, asynchronous method call.
CancelBatch Cancels a pending batch update.
CancelUpdate (ADO) Cancels any changes made to the current or new row of a Recordset object, or the Fields collection of a Record object, before calling the Update method.
CancelUpdate (RDS) Cancels any changes made to the current or new row of a Recordset object.
Clear Removes all the Error objects from the Errors collection.
Clone Creates a duplicate Recordset object from an existing Recordset object. Optionally, specifies that the clone be read-only.
Close Closes an open object and any dependent objects.
CompareBookmarks Compares two bookmarks and returns an indication of their relative values.
ConvertToString (RDS) Converts a Recordset to a MIME string that represents the recordset data.
CopyRecord Copies a file or directory, and its contents, to another location.
CopyTo Copies the specified number of characters or bytes (depending on Type) in the Stream to another Stream object.
CreateObject (RDS) Creates the proxy for the target business object and returns a pointer to it.
CreateParameter Creates a new Parameter object with the specified properties.
CreateRecordset (RDS) Creates an empty, disconnected Recordset.
Delete (ADO Parameters Collection) Deletes an object from the Parameters collection.
Delete (ADO Fields Collection) Deletes an object from the Fields collection.
Delete (ADO Recordset) Deletes the current record or a group of records.
DeleteRecord Deletes a file or directory, and all its subdirectories.
Execute (ADO Command) Executes the query, SQL statement, or stored procedure specified in the CommandText property.
Execute (ADO Connection) Executes the specified query, SQL statement, stored procedure, or provider-specific text.
Find Searches a Recordset for the row that satisfies the specified criteria.
Flush Forces the contents of the Stream remaining in the ADO buffer to the underlying object with which the Stream is associated.
GetChildren Returns a Recordset whose rows represent the files and subdirectories in the directory represented by this Record.
GetChunk Returns all, or a portion of, the contents of a large text or binary data Field object.
GetRows Retrieves multiple records of a Recordset object into an array.
GetString Returns the Recordset as a string.
LoadFromFile Loads the contents of an existing file into a Stream.
Move Moves the position of the current record in a Recordset object.
MoveFirst, MoveLast, MoveNext, and MovePrevious (ADO) Moves to the first, last, next, or previous record in a specified Recordset object and makes that record the current record.
MoveFirst, MoveLast, MoveNext, MovePrevious (RDS) Moves to the first, last, next, or previous record in a specified Recordset object.
MoveRecord Moves a file, or a directory and its contents, to another location.
NextRecordset Clears the current Recordset object and returns the next Recordset by advancing through a series of commands.
Open (ADO Connection) Opens a connection to a data source.
Open (ADO Record) Opens an existing Record object, or creates a new file or directory.
Open (ADO Recordset) Opens a cursor.
Open (ADO Stream) Opens a Stream object to manipulate streams of binary or text data.
OpenSchema Obtains database schema information from the provider.
Query (RDS) Uses a valid SQL query string to return a Recordset.
Read Reads a specified number of bytes from a Stream object.
ReadText Reads a specified number of characters from a text Stream object.
Refresh (ADO) Updates the objects in a collection to reflect objects available from, and specific to, the provider.
Refresh (RDS) Requeries the data source specified in the Connect property and updates the query results.
Requery Updates the data in a Recordset object by re-executing the query on which the object is based.
Reset (RDS) Executes the sort or filter on a client-side Recordset, based on the specified sort and filter properties.
Resync Refreshes the data in the current Recordset object, or Fields collection of a Record object, from the underlying database.
Save Saves the Recordset in a file or Stream object.
SaveToFile Saves the binary contents of a Stream to a file.
Seek Searches the index of a Recordset to quickly locate the row that matches the specified values, and changes the current row position to that row.
SetEOS Sets the position that is the end of the stream.
SkipLine Skips one entire line when reading a text stream.
SubmitChanges (RDS) Submits pending changes of the locally cached and updatable Recordset to the data source specified in the Connect property.
Supports Determines whether a specified Recordset object supports a particular type of functionality.
Update Saves any changes you make to the current row of a Recordset object, or the Fields collection of a Record object.
UpdateBatch Writes all pending batch updates to disk.
Write Writes binary data to a Stream object.
WriteText Writes a specified text string to a Stream object.