Before you can create recordset objects in your program, you typically write application-specific recordset classes. For more information about this preliminary step, see Adding an MFC ODBC Consumer.

Open a dynaset or snapshot object when you need to select records from a data source. The type of object to create depends on what you need to do with the data in your application and on what your ODBC driver supports. For more information, see Dynaset and Snapshot.

To open a recordset

In the constructor, pass a pointer to a CDatabase object or pass NULL to use a temporary database object that the framework constructs and opens based on the connection string returned by the GetDefaultConnect member function. The CDatabase object might already be connected to a data source.

The call to Open uses SQL to select records from the data source. The first record selected (if any) is the current record. The values of this record's fields are stored in the recordset object's field data members. If any records were selected, both the IsBOF and IsEOF member functions return 0.

In your Open call, you can:

• Specify whether the recordset is a dynaset or snapshot. Recordsets open as snapshots by default. Or, you can specify a forward-only recordset, which allows only forward scrolling, one record at a time.

  By default, a recordset uses the default type stored in the CRecordset data member m_nDefaultType. Wizards write code to initialize m_nDefaultType to the recordset type you choose in the wizard. Rather than accepting this default, you can substitute another recordset type.

• Specify a string to replace the default SQL SELECT statement that the recordset constructs.

• Specify whether the recordset is read-only or append-only. Recordsets allow full updating by default, but you can limit that to adding new records only or you can disallow all updates.

The following example shows how to open a read-only snapshot object of class CStudentSet, an application-specific class:

В	Copy Code
// Construct the snapshot object CStudentSet rsStudent( NULL ); // Set options if desired, then open the recordset if(!rsStudent.Open(CRecordset::snapshot, NULL, CRecordset::readOnly)) return FALSE; // Use the snapshot to operate on its records...

After you call Open, use the member functions and data members of the object to work with the records. In some cases, you might want to requery or refresh the recordset to include changes that have occurred on the data source. For more information, see Recordset: Requerying a Recordset (ODBC).

Tip
The connect string you use during development might not be the same connect string that your eventual users need. For ideas about generalizing your application in this regard, see Data Source: Managing Connections (ODBC).

After you construct your recordset object but before you call Open to select records, you might want to set some options to control the recordset's behavior. For all recordsets, you can:

• Specify a filter to constrain record selection.

• Specify a sort order for the records.

• Specify parameters so you can select records using information obtained or calculated at run time.

You can also set the following option if conditions are right:

• If the recordset is updateable and supports locking options, specify the locking method used for updates.

Note
To affect record selection, you must set these options before you call the Open member function.

When you finish with your recordset, you must dispose of it and deallocate its memory.

To close a recordset

Close frees the recordset's HSTMT handle. It does not destroy the C++ object.

Concepts