Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version
Go to top

The Ultimate Toolbox - Updates and User Contributions

, 12 Feb 2013
Updates and User Contributions for the Ultimate Toolbox Libraries
OutlookDemoUpdate.zip
Ultimate Grid
Demos
OutlookStyle
OutlookStyle.aps
OutlookStyle.dsp
OutlookStyle.dsw
OutlookStyle.suo
res
bitmap1.bmp
bmattach.bmp
bmp00001.bmp
bmp00002.bmp
bmp00003.bmp
Flags.bmp
OutlookStyle.ico
OutlookStyleDoc.ico
Toolbar.bmp
toolbar1.bmp
toolbar2.bmp
toolbarf.bmp
UltimateGrid72_Src_Update01.zip
CellTypes
Include
Source
UltimateGrid72_Src_Update02.zip
DataSources
ODBC
OleDB
EditControls
UltimateGrid72_Src_Update03.zip
UltimateGrid72_Src_Update04.zip
UltimateGrid73_src.zip
BuildDLL
Build DLL.dsp
Build DLL.dsw
res
BuildLib
ugmfclib.dsp
ugmfclib.dsw
Lib
Skel
UltimateTCP-IP42_Src_Update01.zip
Ultimate TCP-IP
Include
Security
Include
Source
source
UltimateTCP-IP42_Src_Update02.zip
Examples
Client
Mail
icon1.ico
icon2.ico
MailClientS.suo
test.dsp
test.dsw
UltimateTCP-IP42_Src_Update03.zip
ultimatetoolbox93_src_update01.zip
Ultimate Toolbox
include
source
UltimateToolbox93_Src_Update02.zip
lib
Build DLLs
Build Libs
UltimateToolbox93_Src_Update03.zip
UltimateToolbox93_Src_Update04.zip
UltimateToolbox93_Src_Update05.zip
/***************************************************
// Version: 9.3

// This software along with its related components, documentation and files ("The Libraries")
// is � 1994-2007 The Code Project (1612916 Ontario Limited) and use of The Libraries is
// governed by a software license agreement ("Agreement").  Copies of the Agreement are
// available at The Code Project (www.codeproject.com), as part of the package you downloaded
// to obtain this file, or directly from our office.  For a copy of the license governing
// this software, you may contact us at legalaffairs@codeproject.com, or by calling 416-849-8900.
****************************************************/

#ifndef COXDaoClassDefined
#define COXDaoClassDefined

// v9.3 - update 01 - DAO obsolete in 64-bit - TD
#ifdef _WIN64
#pragma message ("Ultimate Toolbox: DAO classes not available for Win64 platforms - bypassing compilation")
#else
#if _MSC_VER >= 1000
#pragma once
#endif // _MSC_VER >= 1000

#include "OXDllExt.h"
#include "OXMainRes.h"

#ifndef __AFXDAO_H
	#include <afxdao.h>
#endif

#pragma warning(disable : 4995)

#define GFN(nameStr) GetFieldNumber(nameStr)


class OX_CLASS_DECL COXDao
{

protected:
	
	CDaoDatabase* 	m_database;
	CDaoTableDef*	m_tableDef;
	CDaoQueryDef*	m_queryDef;
	CDaoRecordset*	m_recordSet;
	CDaoFieldInfo*  m_fields;

	CString			m_password;

	int				m_lastErrorCode;
	CString			m_lastErrorString;

	void GatherFieldInfo();
	void SetErrorCode(int code);

public:

	COXDao();
	virtual ~COXDao();

	BOOL	Open(LPCTSTR database,LPCTSTR table);
	BOOL	OpenSQL(LPCTSTR database,LPCTSTR sql);
	BOOL	Open(LPCTSTR database,LPCTSTR table,int openType,
				 LPCTSTR sql,int options=0,CString optStr=_T(""));
	BOOL	Close();

	inline	BOOL	IsOpen() const { 
		return (m_database!=NULL ? m_database->IsOpen() : FALSE); 
	}
	inline	BOOL	IsOpenRS() const { 
		return (m_recordSet!=NULL ? m_recordSet->IsOpen() : FALSE); 
	}

	BOOL	GetField(int fieldNum,CString& data);
	BOOL	SetField(int fieldNum,LPCTSTR data);
	
	BOOL	GetField(int fieldNum,short& value);
	BOOL	SetField(int fieldNum,short value);

	BOOL	GetField(int fieldNum,long& value);
	BOOL	SetField(int fieldNum,long value);

	BOOL	GetField(int fieldNum,double& value);
	BOOL	SetField(int fieldNum,double value);

	BOOL	GetField(int fieldNum,float& value);
	BOOL	SetField(int fieldNum,float value);

	BOOL	GetField(int fieldNum,COleDateTime& var);
	BOOL	SetField(int fieldNum,COleDateTime value);

	BOOL	GetField(int fieldNum,COleCurrency& var);
	BOOL	SetField(int fieldNum,COleCurrency value);

	BOOL	GetField(int fieldNum,COleVariant& var);
	BOOL	SetField(int fieldNum,COleVariant var);

	BOOL	GetField(LPCTSTR fieldName,CString& str);
	BOOL	SetField(LPCTSTR fieldName,LPCTSTR str);
	
	BOOL	GetField(int fieldNum,BOOL& value);
	BOOL	SetField(int fieldNum,BOOL value);

	int		GetFieldNumber(LPCTSTR);
	LPCTSTR GetFieldName(int fieldNum);

	long	GetNumberRows();
	int		GetNumberFields();


	BOOL	FindFirst(int fieldNum,CString &string);
	BOOL	FindNext(int fieldNum,CString &string);
	
	BOOL	MoveNext();
	BOOL	MovePrev();
	BOOL	MoveFirst();
	BOOL	MoveLast();

	BOOL	Edit();
	BOOL	Add();
	BOOL	CancelUpdate();
	BOOL	Update();
	BOOL	Delete();

	BOOL	IsEOF();
	BOOL	IsBOF();

	BOOL	SetPassword(LPCTSTR password);

	int		GetLastError();
	LPCTSTR GetLastErrorText();

	CDaoRecordset*	GetRecordSet();
	CDaoDatabase*	GetDatabase();
	CDaoFieldInfo*	GetFieldInfo(int fieldNum);
	CDaoTableDef*	GetTableDef();
	CDaoQueryDef*	GetQueryDef();

};


// error code strings
static LPCTSTR COXDao_errorStrings[] = {	
	_T("COXDao::Open, Exception Thrown during CDAODatabase::Open"),			//0
	_T("COXDao::Open, table and sql parameters both NULL"),					//1
	_T("COXDao::Open, Exception thrown during CDAOTableDef::Open"),			//2
	_T("COXDao::Open, Exception thrown during CDAORecordset::Open"),			//3
	_T("COXDao::Open, Exception thrown during CDAOQueryDef::Open"),			//4
	_T("COXDao::Open, Exception thrown during CDAORecordset::Open"),			//5
	_T("COXDao::Open, Exception thrown during CDaoRecordset::MoveFirst"),		//6
	_T("COXDao::GetField, returned data not compatible with type short"),		//7
	_T("COXDao::GetField, returned data not compatible with type long"),		//8
	_T("COXDao::GetField, returned data not compatible with type double"),	//9
	_T("COXDao::GetField, specified field number is out of range"),			//10
	_T("COXDao::GetField, recordset is not on a valid record"),				//11
	_T("COXDao::GetField, Exception thrown during CDAORecordset::GetFieldValue"), //12
	_T("COXDao::SetField, specified field cannot be updated"),				//13
	_T("COXDao::SetField, specified field number is out of range"),			//14
	_T("COXDao::SetField, Exception thrown during CDAORecordset::SetFieldValue"), //15
	_T("COXDao::GetField, returned data not compatible with type CString"),	//16
	_T("NA"),																//17
	_T("COXDao::GetNumRows, Exception thrown during CDAORecordset::MoveNext"),//18
	_T("COXDao::GetFieldNumber, field name not found in table"),				//19
	_T("COXDao::GetFieldName, specified field number is out of range"),		//20
	_T("COXDao::GetFieldInfo, specified field number is out of range"),		//21
	_T("COXDao::FindFirst, Exception thrown during CDAORecordset::FindFirst"),//22
	_T("COXDao::FindNext, Exception thrown during CDAORecordset::FindNext"),	//23
	_T("COXDao::MoveFirst, Exception thrown during CDaoRecordset::MoveFirst"),//24
	_T("COXDao::MoveNext, Exception thrown during CDaoRecordset::MoveNext"),	//25
	_T("COXDao::MovePrev, Exception thrown during CDaoRecordset::MovePrev"),	//26
	_T("COXDao::MoveLast, Exception thrown during CDaoRecordset::MoveLast"),	//27
	_T("COXDao::Update, Exception thrown during CDaoRecordset::Update"),		//28
	_T("COXDao::CancelUpdate, Exception thrown during CDaoRecordset::CancelUpdate"), //29
	_T("COXDao::Edit, Exception thrown during CDaoRecordset::Edit"),			//30
	_T("COXDao::Add, Exception thrown during CDaoRecordset::AddNew"),			//31
	_T("COXDao::Delete, Exception thrown during CDaoRecordset::Delete"),		//31
	_T("")
	};

#endif	// _WIN64
#endif

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

The Ultimate Toolbox
Web Developer
Canada Canada
In January 2005, David Cunningham and Chris Maunder created TheUltimateToolbox.com, a new group dedicated to the continued development, support and growth of Dundas Software’s award winning line of MFC, C++ and ActiveX control products.
 
Ultimate Grid for MFC, Ultimate Toolbox for MFC, and Ultimate TCP/IP have been stalwarts of C++/MFC development for a decade. Thousands of developers have used these products to speed their time to market, improve the quality of their finished products, and enhance the reliability and flexibility of their software.
Group type: Organisation

387 members


| Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 13 Feb 2013
Article Copyright 2008 by The Ultimate Toolbox
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid