CDatabaseRecordset::OpenRecordset

[This is preliminary documentation and subject to change.]

The OpenRecordset method opens the specified recordset in the Guide database.

BOOL OpenRecordset(
  LPCTSTR WhereBy,  
  long lType        
);
 

Parameters

WhereBy

A SQL WHERE clause that specifies the recordset criteria. Only records that match this parameter will be opened.

lType

An optional parameter that specifies whether the Jet database engine opens the recordset as a snapshot or a dynaset.

This parameter can be one of the following values.

Value	Meaning
dbOpenSnapshot	Open the recordset as a snapshot, in other words, create a fixed copy of the records in the table.
dbOpenDynaset	Open the recordset as a dynaset, a set of pointers to the records in a table. This is the default.

Return Values

If the recordset was successfully opened, this method returns TRUE. Otherwise it returns FALSE.

Remarks

You can reuse recordset objects by opening and closing a single recordset object multiple times. This is more efficient than deleting and creating a new instance of a recordset object.

The record count is not automatically defined when you open a recordset. Therefore, when you call GetRecordCount, the method must move to the last record in the set. This can be slow for large recordsets. However, recordsets opened with an ORDER BY clause correctly set the initial record count.

In the case of large recordsets, opening the recordset as a snapshot can degrade performance.

QuickInfo

  Windows NT: Unsupported.
  Windows: Requires Windows 98.
  Windows CE: Unsupported.
  Header: Declared in dbsets.h.
  Import Library: Use dbsets.lib or dbsetsSt.lib.
  Unicode: Yes.