CDaoRecordView Class

 

The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.microsoft.com.

The latest version of this topic can be found at CDaoRecordView Class.

A view that displays database records in controls.

class AFX_NOVTABLE CDaoRecordView : public CFormView  

Protected Constructors

NameDescription
CDaoRecordView::CDaoRecordViewConstructs a CDaoRecordView object.

Public Methods

NameDescription
CDaoRecordView::IsOnFirstRecordReturns nonzero if the current record is the first record in the associated recordset.
CDaoRecordView::IsOnLastRecordReturns nonzero if the current record is the last record in the associated recordset.
CDaoRecordView::OnGetRecordsetReturns a pointer to an object of a class derived from CDaoRecordset. ClassWizard overrides this function for you and creates the recordset if necessary.
CDaoRecordView::OnMoveIf the current record has changed, updates it on the data source, then moves to the specified record (next, previous, first, or last).

The view is a form view directly connected to a CDaoRecordset object. The view is created from a dialog template resource and displays the fields of the CDaoRecordset object in the dialog template's controls. The CDaoRecordView object uses dialog data exchange (DDX) and DAO record field exchange (DFX) to automate the movement of data between the controls on the form and the fields of the recordset. CDaoRecordView also supplies a default implementation for moving to the first, next, previous, or last record and an interface for updating the record currently in view.

System_CAPS_ICON_note.jpg Note

The DAO database classes are distinct from the MFC database classes based on Open Database Connectivity (ODBC). All DAO database class names have the "CDao" prefix. You can still access ODBC data sources with the DAO classes; the DAO classes generally offer superior capabilities because they use the Microsoft Jet database engine.

The most common way to create your record view is with the Application Wizard. The Application Wizard creates both the record view class and its associated recordset class as part of your skeleton starter application.

If you simply need a single form, the Application Wizard approach is easier. ClassWizard lets you decide to use a record view later in the development process. If you don't create the record view class with the Application Wizard, you can create it later with ClassWizard. Using ClassWizard to create a record view and a recordset separately and then connect them is the most flexible approach because it gives you more control in naming the recordset class and its .H/.CPP files. This approach also lets you have multiple record views on the same recordset class.

To make it easy for end-users to move from record to record in the record view, the Application Wizard creates menu (and optionally toolbar) resources for moving to the first, next, previous, or last record. If you create a record view class with ClassWizard, you need to create these resources yourself with the menu and bitmap editors.

For information about the default implementation for moving from record to record, see IsOnFirstRecord and IsOnLastRecord and the article Using a Record View, which applies to both CRecordView and CDaoRecordView.

CDaoRecordView keeps track of the user's position in the recordset so that the record view can update the user interface. When the user moves to either end of the recordset, the record view disables user interface objects — such as menu items or toolbar buttons — for moving further in the same direction.

For more information about declaring and using your record view and recordset classes, see "Designing and Creating a Record View" in the article Record Views. For more information about how record views work and how to use them, see the article Using a Record View. All the articles mentioned above apply to both CRecordView and CDaoRecordView.

CObject

CCmdTarget

CWnd

CView

CScrollView

CFormView

CDaoRecordView

Header: afxdao.h

When you create an object of a type derived from CDaoRecordView, call either form of the constructor to initialize the view object and identify the dialog resource on which the view is based.

explicit CDaoRecordView(LPCTSTR lpszTemplateName);  
explicit CDaoRecordView(UINT nIDTemplate);
```  
  
### Parameters  
 `lpszTemplateName`  
 Contains a null-terminated string that is the name of a dialog template resource.  
  
 `nIDTemplate`  
 Contains the ID number of a dialog template resource.  
  
### Remarks  
 You can either identify the resource by name (pass a string as the argument to the constructor) or by its ID (pass an unsigned integer as the argument). Using a resource ID is recommended.  
  
> [!NOTE]
>  Your derived class must supply its own constructor. In the constructor of your derived class, call the constructor `CDaoRecordView::CDaoRecordView` with the resource name or ID as an argument.  
  
 **CDaoRecordView::OnInitialUpdate** calls `CWnd::UpdateData`, which calls `CWnd::DoDataExchange`. This initial call to `DoDataExchange` connects `CDaoRecordView` controls (indirectly) to `CDaoRecordset` field data members created by ClassWizard. These data members cannot be used until after you call the base class **CFormView::OnInitialUpdate** member function.  
  
> [!NOTE]
>  If you use ClassWizard, the wizard defines an `enum` value `CDaoRecordView::IDD` in the class declaration and uses it in the member initialization list for the constructor.  
  
 [!CODE [NVC_MFCDatabase#35](../CodeSnippet/VS_Snippets_Cpp/NVC_MFCDatabase#35)]  
  
##  <a name="cdaorecordview__isonfirstrecord"></a>  CDaoRecordView::IsOnFirstRecord  
 Call this member function to determine whether the current record is the first record in the recordset object associated with this record view.  
  

BOOL IsOnFirstRecord();

  
### Return Value  
 Nonzero if the current record is the first record in the recordset; otherwise 0.  
  
### Remarks  
 This function is useful for writing your own implementations of the default command update handlers written by ClassWizard.  
  
 If the user moves to the first record, the framework disables any user interface objects (for example, menu items or toolbar buttons) you have for moving to the first or the previous record.  
  
##  <a name="cdaorecordview__isonlastrecord"></a>  CDaoRecordView::IsOnLastRecord  
 Call this member function to determine whether the current record is the last record in the recordset object associated with this record view.  
  

BOOL IsOnLastRecord();

  
### Return Value  
 Nonzero if the current record is the last record in the recordset; otherwise 0.  
  
### Remarks  
 This function is useful for writing your own implementations of the default command update handlers that ClassWizard writes to support a user interface for moving from record to record.  
  
> [!CAUTION]
>  The result of this function is reliable except that the view may not be able to detect the end of the recordset until the user has moved past it. The user might have to move beyond the last record before the record view can tell that it must disable any user interface objects for moving to the next or last record. If the user moves past the last record and then moves back to the last record (or before it), the record view can track the user's position in the recordset and disable user interface objects correctly.  
  
##  <a name="cdaorecordview__ongetrecordset"></a>  CDaoRecordView::OnGetRecordset  
 Returns a pointer to the `CDaoRecordset`-derived object associated with the record view.  
  

virtual CDaoRecordset* OnGetRecordset() = 0;

  
### Return Value  
 A pointer to a `CDaoRecordset`-derived object if the object was successfully created; otherwise a **NULL** pointer.  
  
### Remarks  
 You must override this member function to construct or obtain a recordset object and return a pointer to it. If you declare your record view class with ClassWizard, the wizard writes a default override for you. ClassWizard's default implementation returns the recordset pointer stored in the record view if one exists. If not, it constructs a recordset object of the type you specified with ClassWizard and calls its **Open** member function to open the table or run the query, and then returns a pointer to the object.  
  
 For more information and examples, see the article [Record Views: Using a Record View](../Topic/Using%20a%20Record%20View%20%20\(MFC%20Data%20Access\).md).  
  
##  <a name="cdaorecordview__onmove"></a>  CDaoRecordView::OnMove  
 Call this member function to move to a different record in the recordset and display its fields in the controls of the record view.  
  

virtual BOOL OnMove(UINT nIDMoveCommand);

  
### Parameters  
 `nIDMoveCommand`  
 One of the following standard command ID values:  
  
- `ID_RECORD_FIRST` Move to the first record in the recordset.  
  
- `ID_RECORD_LAST` Move to the last record in the recordset.  
  
- `ID_RECORD_NEXT` Move to the next record in the recordset.  
  
- `ID_RECORD_PREV` Move to the previous record in the recordset.  
  
### Return Value  
 Nonzero if the move was successful; otherwise 0 if the move request was denied.  
  
### Remarks  
 The default implementation calls the appropriate Move member function of the `CDaoRecordset` object associated with the record view.  
  
 By default, `OnMove` updates the current record on the data source if the user has changed it in the record view.  
  
 The Application Wizard creates a menu resource with First Record, Last Record, Next Record, and Previous Record menu items. If you select the Initial Toolbar option, the Application Wizard also creates a toolbar with buttons corresponding to these commands.  
  
 If you move past the last record in the recordset, the record view continues to display the last record. If you move backward past the first record, the record view continues to display the first record.  
  
> [!CAUTION]
>  Calling `OnMove` throws an exception if the recordset has no records. Call the appropriate user interface update handler function — **OnUpdateRecordFirst**, **OnUpdateRecordLast**, **OnUpdateRecordNext**, or **OnUpdateRecordPrev** — before the corresponding move operation to determine whether the recordset has any records.  
  
## See Also  
 [CFormView Class](../Topic/CFormView%20Class.md)   
 [Hierarchy Chart](../Topic/Hierarchy%20Chart.md)   
 [CDaoRecordset Class](../Topic/CDaoRecordset%20Class.md)   
 [CDaoTableDef Class](../Topic/CDaoTableDef%20Class.md)   
 [CDaoQueryDef Class](../Topic/CDaoQueryDef%20Class.md)   
 [CDaoDatabase Class](../Topic/CDaoDatabase%20Class.md)   
 [CDaoWorkspace Class](../Topic/CDaoWorkspace%20Class.md)   
 [CFormView Class](../Topic/CFormView%20Class.md)





Show: