mtdaorecordset.h

VC6++ program demo source for communication with PLC to read and write data.

	BOOL FindNext(LPCTSTR lpszFilter)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::FindNext(lpszFilter);
	}
	BOOL FindPrev(LPCTSTR lpszFilter)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::FindPrev(lpszFilter);
	}
	BOOL FindFirst(LPCTSTR lpszFilter)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::FindFirst(lpszFilter);
	}
	BOOL FindLast(LPCTSTR lpszFilter)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::FindLast(lpszFilter);
	}
	virtual BOOL Find(long lFindType, LPCTSTR lpszFilter)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::Find(lFindType, lpszFilter);
	}

	COleVariant GetBookmark()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetBookmark();
	}
	void SetBookmark(COleVariant varBookmark)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetBookmark(varBookmark);
	}
	long GetAbsolutePosition()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetAbsolutePosition();
	}
	void SetAbsolutePosition(long lPosition)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetAbsolutePosition(lPosition);
	}
	float GetPercentPosition()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetPercentPosition();
	}
	void SetPercentPosition(float fPosition)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetPercentPosition(fPosition);
	}

	// seek allowed on recordset opened as tables (max keys = 13)
	BOOL Seek(LPCTSTR lpszComparison, COleVariant* pKey1,
		COleVariant* pKey2 = NULL, COleVariant* pKey3 = NULL)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return 	CDaoRecordset::Seek(lpszComparison, pKey1, pKey2, pKey3);
	}
	BOOL Seek(LPCTSTR lpszComparison, COleVariant* pKeyArray, WORD nKeys)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::Seek(lpszComparison, pKeyArray, nKeys);
	}

	// edit buffer operations
	virtual void AddNew()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::AddNew();
	}
	virtual void Edit()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::Edit();
	}
	virtual void Update()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::Update();
	}
	virtual void Delete()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::Delete();
	}
	virtual void CancelUpdate()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::CancelUpdate();
	}

	// field operations
	virtual void GetFieldValue(LPCTSTR lpszName, COleVariant& varValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetFieldValue(lpszName, varValue);
	}
	virtual void GetFieldValue(int nIndex, COleVariant& varValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetFieldValue(nIndex, varValue);
	}
	virtual void SetFieldValue(LPCTSTR lpszName,
		const COleVariant& varValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldValue(lpszName, varValue);
	}
	virtual void SetFieldValue(int nIndex,
		const COleVariant& varValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldValue(nIndex, varValue);
	}
	void SetFieldValue(int nIndex, LPCTSTR lpszValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldValue(nIndex, lpszValue);
	}
	void SetFieldValue(LPCTSTR lpszName, LPCTSTR lpszValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldValue(lpszName, lpszValue);
	}
	void SetFieldValueNull(LPCTSTR lpszName)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldValueNull(lpszName);
	}
	void SetFieldValueNull(int nIndex)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldValueNull(nIndex);
	}

	virtual COleVariant GetParamValue(LPCTSTR lpszName)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetParamValue(lpszName);
	}
	virtual COleVariant GetParamValue(int nIndex)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetParamValue(nIndex);
	}
	virtual void SetParamValue(LPCTSTR lpszName,
		const COleVariant& varValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetParamValue(lpszName, varValue);
	}
	virtual void SetParamValue(int nIndex,
		const COleVariant& varValue)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetParamValue(nIndex, varValue);
	}
	void SetParamValueNull(LPCTSTR lpszName)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetParamValueNull(lpszName);
	}
	void SetParamValueNull(int nIndex)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetParamValueNull(nIndex);
	}

	void SetFieldDirty(void* pv, BOOL bDirty = TRUE)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldDirty(pv, bDirty);
	}
	void SetFieldNull(void* pv, BOOL bNull = TRUE)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetFieldNull(pv, bNull);
	}

	void SetLockingMode(BOOL bPessimistic)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetLockingMode(bPessimistic);
	}
	BOOL GetLockingMode()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetLockingMode();
	}

	// Recordset operations
	virtual void Requery()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::Requery();
	}

	// Jet's remote data caching operations
	void SetCacheStart(COleVariant varBookmark)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetCacheStart(varBookmark);
	}
	COleVariant GetCacheStart()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetCacheStart();
	}
	void SetCacheSize(long lSize)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetCacheSize(lSize);
	}
	long GetCacheSize()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetCacheSize();
	}
	void FillCache(long* pSize = NULL, COleVariant* pBookmark = NULL)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::FillCache(pSize, pBookmark);
	}

	short GetFieldCount()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetFieldCount();
	}
	void GetFieldInfo(int nIndex, CDaoFieldInfo& fieldinfo,
		DWORD dwInfoOptions = AFX_DAO_PRIMARY_INFO)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetFieldInfo(nIndex, fieldinfo, dwInfoOptions);
	}
	void GetFieldInfo(LPCTSTR lpszName, CDaoFieldInfo& fieldinfo,
		DWORD dwInfoOptions = AFX_DAO_PRIMARY_INFO)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetFieldInfo(lpszName, fieldinfo, dwInfoOptions);
	}

	short GetIndexCount()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetIndexCount();
	}
	void GetIndexInfo(int nIndex, CDaoIndexInfo& indexinfo,
		DWORD dwInfoOptions = AFX_DAO_PRIMARY_INFO)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetIndexInfo(nIndex, indexinfo, dwInfoOptions);
	}
	void GetIndexInfo(LPCTSTR lpszName, CDaoIndexInfo& indexinfo,
		DWORD dwInfoOptions = AFX_DAO_PRIMARY_INFO)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetIndexInfo(lpszName, indexinfo, dwInfoOptions);
	}

// Overridables
public:
	virtual CString GetDefaultDBName()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetDefaultDBName();
	}
	virtual CString GetDefaultSQL()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetDefaultSQL();
	}

	// for recordset field exchange
	virtual void DoFieldExchange(CDaoFieldExchange* pFX)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::DoFieldExchange(pFX);
	}

// Implementation
public:
	virtual ~CMTDaoRecordset()
	{
	}

	// Out-of-date functions kept for backward compatability
	virtual COleVariant GetFieldValue(LPCTSTR lpszName)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetFieldValue(lpszName);
	}
	virtual COleVariant GetFieldValue(int nIndex)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetFieldValue(nIndex);
	}

#ifdef _DEBUG
	virtual void AssertValid() const
	{
		CDaoRecordset::AssertValid();
	}
	virtual void Dump(CDumpContext& dc) const
	{
		CDaoRecordset::Dump(dc);
	}
#endif

	void SetCursorAttributes()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetCursorAttributes();
	}
	void GetDataAndFixupNulls()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::GetDataAndFixupNulls();
	}
	DWORD GetFieldLength(int nFieldIndex)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::GetFieldLength(nFieldIndex);
	}

	BOOL IsFieldStatusDirty(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::IsFieldStatusDirty(nField);
	}
	void SetDirtyFieldStatus(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetDirtyFieldStatus(nField);
	}
	void ClearDirtyFieldStatus(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::ClearDirtyFieldStatus(nField);
	}

	BOOL IsFieldStatusNull(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::IsFieldStatusNull(nField);
	}
	void SetNullFieldStatus(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetNullFieldStatus(nField);
	}
	void ClearNullFieldStatus(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::ClearNullFieldStatus(nField);
	}

	BOOL IsFieldStatusNullable(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::IsFieldStatusNullable(nField);
	}
	void SetNullableFieldStatus(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetNullableFieldStatus(nField);
	}

	BOOL IsFieldStatusNullableKnown(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::IsFieldStatusNullableKnown(nField);
	}
	void SetNullableKnownFieldStatus(UINT nField)
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::SetNullableKnownFieldStatus(nField);
	}

	void ClearFieldStatusFlags()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		CDaoRecordset::ClearFieldStatusFlags();
	}
	BOOL IsMatch()
	{
		CSingleLock sl(&CMTDaoDatabase::m_cs, TRUE);
		return CDaoRecordset::IsMatch();
	}
};


#endif // !defined(AFX_MTDAORECORDSET_H__AF2EC5F0_1722_455F_8407_AC68B467139F__INCLUDED_)