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. |
| 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. |