fmodbcsqlset.cpp

本例要使用的ODBC数据源名为LocalServer

// fmodbcsqlSet.cpp : implementation of the CFmodbcsqlSet class
//

#include "stdafx.h"
#include "fmodbcsql.h"
#include "fmodbcsqlSet.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CFmodbcsqlSet implementation

IMPLEMENT_DYNAMIC(CFmodbcsqlSet, CRecordset)

CFmodbcsqlSet::CFmodbcsqlSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CFmodbcsqlSet)
	m_Class_code = _T("");
	m_Student_number = _T("");
	m_Name = _T("");
	m_Sex = _T("");
	m_Native_place = _T("");
	m_Remark = _T("");
	m_nFields = 6;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CFmodbcsqlSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=LocalServer");
}

CString CFmodbcsqlSet::GetDefaultSQL()
{
	return _T("[dbo].[student]");
}

void CFmodbcsqlSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CFmodbcsqlSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[Class_code]"), m_Class_code);
	RFX_Text(pFX, _T("[Student_number]"), m_Student_number);
	RFX_Text(pFX, _T("[Name]"), m_Name);
	RFX_Text(pFX, _T("[Sex]"), m_Sex);
	RFX_Text(pFX, _T("[Native_place]"), m_Native_place);
	RFX_Text(pFX, _T("[Remark]"), m_Remark);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CFmodbcsqlSet diagnostics

#ifdef _DEBUG
void CFmodbcsqlSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CFmodbcsqlSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG