recordset object

This section describes the sequence of RFX events as a recordset object is opened and as you add, update, and delete records.

Sometimes you might want to put a list box or combo box control in your record view and fill it with values from a second recordset object.

Construct a new recordset object (or prepare to call Requery for an existing object).

Construct a new recordset object (or prepare to call Requery for an existing one).

Define a Connection object and a Recordset object, and then execute the Open method on the Connection object.

Bookmarks associated with one recordset object are valid on a second recordset.

This establishes the recordset object as an edit buffer containing the columns of the first record.

Note: An error will occur if the Recordset object does not support bookmarks or backward cursor movement.

Provide dialog data exchange (DDX) between the form controls and the associated recordset object.

The ADO Recordset object is used to hold a set of records from a database table.

As a result, you use a considerably simpler class interface to manipulate records through a recordset object.

Declare a recordset object as a local variable in a function.

The recordset object's field data members, taken together, constitute an edit buffer that holds the selected columns of one record.

Form-based applications usually store a pointer to a recordset object in the view.

The join operation, a common data-access task, lets you work with data from more than one table using a single recordset object.

You must specify parameter values before you call Open (for a new recordset object) or Requery (for an existing one).

The values of this record's fields are stored in the recordset object's field data members.

Identifies the effect of committing a transaction on an open recordset object.

Identifies the effect of rolling back a transaction on an open recordset object.

A recordset object gives you access to all the selected records.

The Collection is assigned to either a Command object, Connection object, Field object, or a Recordset object.

View all methods and properties of the Recordset object.

ADO applications use the Delete method of the Recordset object.

When you finish using the recordset object, you close and destroy it.

By default, a record view is associated with a single recordset object, whose fields are mapped to the record view's controls.

RFX and DFX move data between the current record of the data source and the field data members of a recordset object.

Clears the current Recordset object and returns the next Recordset object by looping through a series of commands

Sets or returns the name of the current index for a Recordset object

Copies multiple records from a Recordset object into a two-dimensional array

Sets or returns the maximum number of records allowed on a single page of a Recordset object

Saves all changes made to a single record in a Recordset object

Returns a value that describes if the Recordset object is open, closed, connecting, executing or retrieving data

Exchange data between a database and a recordset object

Sets or returns a value that specifies the ordinal position of the current record in the Recordset object

Retrieves the rest of the records in the Recordset object

When you call a recordset object's Open member function, Open constructs a SQL statement using some or all of the following ingredients

Sets or returns the cursor type of a Recordset object

Indicates the number of Field objects in the Recordset object

To pass parameter values to a recordset object at run time

Sets or returns a filter for the data in a Recordset object

Contains all the Property objects in the Recordset object

To specify a filter for a recordset object

The following RFX activities occur, in the order shown, when you call a recordset object's Open member function

Moves the record pointer in a Recordset object

Sets or returns a value that specifies the page number in the Recordset object

To specify a sort order for a recordset object