// UsCustRecordset.cpp : implementation file
//
/* 
 * This sample application and corresponding sample code is provided 
 * for example purposes only.  It has not undergone rigorous testing
 * and as such should not be shipped as part of a final application
 * without extensive testing on the part of the organization releasing
 * the end-user product.
 */

#include "stdafx.h"
#include "mapxsamp.h"
#include "UsCustRecordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUsCustRecordset

IMPLEMENT_DYNAMIC(CUsCustRecordset, CDaoRecordset)

CUsCustRecordset::CUsCustRecordset(CDaoDatabase* pdb)
	: CDaoRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CUsCustRecordset)
	m_LNAME = _T("");
	m_FNAME = _T("");
	m_TERR = _T("");
	m_COMPANY = _T("");
	m_CITY = _T("");
	m_STATE = _T("");
	m_ZIP = _T("");
	m_ORDER_AMT = 0.0;
	m_X = 0.0;
	m_Y = 0.0;
	m_nFields = 10;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dbOpenDynaset;
}

static char BASED_CODE szDataFilter[] = "Access Databases (*.mdb)|*.mdb|All Files (*.*)|*.*||";

CString CUsCustRecordset::GetDefaultDBName()
{
//	return _T("C:\\Program Files\\MapInfo MapX 4.0\\Data\\MapStats.mdb");
	CString str = _T("C:\\Program Files\\MapInfo\\MapX 5.0\\Data\\MapStats.mdb");
	CFileDialog dlgFile(TRUE, "*.mdb", str, 0, szDataFilter, NULL);

	dlgFile.m_ofn.lpstrTitle = _T("Find Mapstats.mdb");

	if (dlgFile.DoModal() == IDCANCEL) {
		return str;
	}

	return dlgFile.GetPathName();
}

CString CUsCustRecordset::GetDefaultSQL()
{
	return _T("[US_CUST]");
}

void CUsCustRecordset::DoFieldExchange(CDaoFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CUsCustRecordset)
	pFX->SetFieldType(CDaoFieldExchange::outputColumn);
	DFX_Text(pFX, _T("[LNAME]"), m_LNAME);
	DFX_Text(pFX, _T("[FNAME]"), m_FNAME);
	DFX_Text(pFX, _T("[TERR]"), m_TERR);
	DFX_Text(pFX, _T("[COMPANY]"), m_COMPANY);
	DFX_Text(pFX, _T("[CITY]"), m_CITY);
	DFX_Text(pFX, _T("[STATE]"), m_STATE);
	DFX_Text(pFX, _T("[ZIP]"), m_ZIP);
	DFX_Double(pFX, _T("[ORDER_AMT]"), m_ORDER_AMT);
	DFX_Double(pFX, _T("[X]"), m_X);
	DFX_Double(pFX, _T("[Y]"), m_Y);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CUsCustRecordset diagnostics

#ifdef _DEBUG
void CUsCustRecordset::AssertValid() const
{
	CDaoRecordset::AssertValid();
}

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