Class CDaoRecordset

Class CDaoRecordsetCObject

|

+--CDaoRecordset

in AFXDAO.H

class CDaoRecordset

extends CObject

CDaoRecordset - the result of a query or base table browse

Field Summary

protected BOOL

m_bAppendable

BOOL

m_bCheckCacheForDirtyFields

protected BOOL

m_bDeleted

protected BOOL

m_bOpen

protected BOOL

m_bScrollable

DWORD

m_cbFixedLengthFields

DAOFETCHROWS

m_DaoFetchRows

protected int

m_nDefaultType

int

m_nFields

protected int

m_nOpenType

protected int

m_nOptions

int

m_nParams

protected int

m_nStatus

BYTE*

m_pbFieldFlags

BYTE*

m_pbParamFlags

DAOFields*

m_pDAOFields

DAOIndexes*

m_pDAOIndexes

DAORecordset*

m_pDAORecordset

CDaoDatabase*

m_pDatabase

ICDAORecordset*

m_pICDAORecordsetGetRows

CMapPtrToPtr*

m_pMapFieldCache

CMapPtrToPtr*

m_pMapFieldIndex

CDaoQueryDef*

m_pQueryDef

DAOCOLUMNBINDING*

m_prgDaoColBindInfo

CDaoTableDef*

m_pTableDef

DWORD*

m_pulColumnLengths

CString

m_strFilter

protected CString

m_strRequeryFilter

protected CString

m_strRequerySort

protected CString

m_strRequerySQL

CString

m_strSort

CString

m_strSQL

Fields inherited from class CObject

classCObject

Constructor Summary

CDaoRecordset( CDaoDatabase* pDatabase = NULL )

virtual ~CDaoRecordset()

Method Summary

virtual void

AddNew()

protected void

AllocCache()

protected void

AllocDatabase()

protected void

BindFields()

protected void

BindParameters()

protected void

BuildParameterList()

protected void

BuildSelectList()

protected void

BuildSQL()

BOOL

CanAppend() const

BOOL

CanBookmark()

virtual void

CancelUpdate()

BOOL

CanRestart()

BOOL

CanScroll() const

BOOL

CanTransact()

BOOL

CanUpdate() const

void

ClearDirtyFieldStatus( UINT nField )

void

ClearFieldStatusFlags()

void

ClearNullFieldStatus( UINT nField )

virtual void

Close()

virtual void

Delete()

virtual void

DoFieldExchange( CDaoFieldExchange* pFX )

virtual void

Edit()

void

FillCache( long* pSize = NULL, COleVariant* pBookmark = NULL )

virtual BOOL

Find( long lFindType, LPCTSTR lpszFilter )

BOOL

FindFirst( LPCTSTR lpszFilter )

BOOL

FindLast( LPCTSTR lpszFilter )

BOOL

FindNext( LPCTSTR lpszFilter )

BOOL

FindPrev( LPCTSTR lpszFilter )

protected void

Fixup()

protected void

FreeCache()

long

GetAbsolutePosition()

COleVariant

GetBookmark()

long

GetCacheSize()

COleVariant

GetCacheStart()

CString

GetCurrentIndex()

void

GetDataAndFixupNulls()

COleDateTime

GetDateCreated()

COleDateTime

GetDateLastUpdated()

virtual CString

GetDefaultDBName()

virtual CString

GetDefaultSQL()

short

GetEditMode()

short

GetFieldCount()

protected int

GetFieldIndex( void* pv )

void

GetFieldInfo( LPCTSTR lpszName, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 )

void

GetFieldInfo( int nIndex, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 )

DWORD

GetFieldLength( int nFieldIndex )

virtual void

GetFieldValue( LPCTSTR lpszName, COleVariant& varValue )

virtual void

GetFieldValue( int nIndex, COleVariant& varValue )

virtual COleVariant

GetFieldValue( LPCTSTR lpszName )

virtual COleVariant

GetFieldValue( int nIndex )

short

GetIndexCount()

void

GetIndexInfo( int nIndex, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 )

void

GetIndexInfo( LPCTSTR lpszName, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 )

COleVariant

GetLastModifiedBookmark()

BOOL

GetLockingMode()

CString

GetName()

virtual COleVariant

GetParamValue( LPCTSTR lpszName )

virtual COleVariant

GetParamValue( int nIndex )

float

GetPercentPosition()

long

GetRecordCount()

CString

GetSQL() const

short

GetType()

CString

GetValidationRule()

CString

GetValidationText()

protected void

InitFieldsCollection()

protected void

InitIndexesCollection()

BOOL

IsBOF() const

BOOL

IsDeleted() const

BOOL

IsEOF() const

BOOL

IsFieldDirty( void* pv )

BOOL

IsFieldNull( void* pv )

BOOL

IsFieldNullable( void* pv )

BOOL

IsFieldStatusDirty( UINT nField )

BOOL

IsFieldStatusNull( UINT nField )

BOOL

IsFieldStatusNullable( UINT nField )

BOOL

IsFieldStatusNullableKnown( UINT nField )

BOOL

IsMatch()

BOOL

IsOpen() const

protected void

LoadFields()

protected void

MarkForAddNew()

protected void

MarkForEdit()

virtual void

Move( long lRows )

void

MoveFirst()

void

MoveLast()

void

MoveNext()

void

MovePrev()

virtual void

Open( CDaoQueryDef* pQueryDef, int nOpenType = dbOpenDynaset, int nOptions = 0 )

virtual void

Open( int nOpenType =(-1 L ), LPCTSTR lpszSQL = NULL, int nOptions = 0 )

virtual void

Open( CDaoTableDef* pTableDef, int nOpenType = dbOpenTable, int nOptions = 0 )

virtual void

Requery()

BOOL

Seek( LPCTSTR lpszComparison, COleVariant* pKey1, COleVariant* pKey2 = NULL, COleVariant* pKey3 = NULL )

BOOL

Seek( LPCTSTR lpszComparison, COleVariant* pKeyArray, WORD nKeys )

void

SetAbsolutePosition( long lPosition )

void

SetBookmark( COleVariant varBookmark )

void

SetCacheSize( long lSize )

void

SetCacheStart( COleVariant varBookmark )

void

SetCurrentIndex( LPCTSTR lpszIndex )

void

SetCursorAttributes()

protected virtual void

SetDirtyFields()

void

SetDirtyFieldStatus( UINT nField )

void

SetFieldDirty( void* pv, BOOL bDirty = TRUE )

void

SetFieldNull( void* pv, BOOL bNull = TRUE )

virtual void

SetFieldValue( LPCTSTR lpszName, const COleVariant& varValue )

void

SetFieldValue( int nIndex, LPCTSTR lpszValue )

void

SetFieldValue( LPCTSTR lpszName, LPCTSTR lpszValue )

virtual void

SetFieldValue( int nIndex, const COleVariant& varValue )

void

SetFieldValueNull( int nIndex )

void

SetFieldValueNull( LPCTSTR lpszName )

void

SetLockingMode( BOOL bPessimistic )

void

SetNullableFieldStatus( UINT nField )

void

SetNullableKnownFieldStatus( UINT nField )

void

SetNullFieldStatus( UINT nField )

virtual void

SetParamValue( int nIndex, const COleVariant& varValue )

virtual void

SetParamValue( LPCTSTR lpszName, const COleVariant& varValue )

void

SetParamValueNull( LPCTSTR lpszName )

void

SetParamValueNull( int nIndex )

void

SetPercentPosition( float fPosition )

protected void

StoreFields()

static void AFX_CDECL

StripBrackets( LPCTSTR lpszSrc, LPTSTR lpszDest )

protected virtual void

ThrowDaoException( int nError = 0 )

virtual void

Update()

Methods inherited from class CObject

GetRuntimeClass, new, new, delete, IsSerializable, IsKindOf, Serialize

Field Detail

m_bAppendableprotected BOOL m_bAppendable;

m_bCheckCacheForDirtyFieldspublic BOOL m_bCheckCacheForDirtyFields;

m_bDeletedprotected BOOL m_bDeleted;

m_bOpenprotected BOOL m_bOpen;

m_bScrollableprotected BOOL m_bScrollable;

m_cbFixedLengthFieldspublic DWORD m_cbFixedLengthFields;

m_DaoFetchRowspublic DAOFETCHROWS m_DaoFetchRows;

m_nDefaultTypeprotected int m_nDefaultType;

m_nFieldspublic int m_nFields;

m_nOpenTypeprotected int m_nOpenType;

m_nOptionsprotected int m_nOptions;

m_nParamspublic int m_nParams;

m_nStatusprotected int m_nStatus;

m_pbFieldFlagspublic BYTE* m_pbFieldFlags;

m_pbParamFlagspublic BYTE* m_pbParamFlags;

m_pDAOFieldspublic DAOFields* m_pDAOFields;

m_pDAOIndexespublic DAOIndexes* m_pDAOIndexes;

m_pDAORecordsetpublic DAORecordset* m_pDAORecordset;

m_pDatabasepublic CDaoDatabase* m_pDatabase;

m_pICDAORecordsetGetRowspublic ICDAORecordset* m_pICDAORecordsetGetRows;

m_pMapFieldCachepublic CMapPtrToPtr* m_pMapFieldCache;

m_pMapFieldIndexpublic CMapPtrToPtr* m_pMapFieldIndex;

m_pQueryDefpublic CDaoQueryDef* m_pQueryDef;

m_prgDaoColBindInfopublic DAOCOLUMNBINDING* m_prgDaoColBindInfo;

m_pTableDefpublic CDaoTableDef* m_pTableDef;

m_pulColumnLengthspublic DWORD* m_pulColumnLengths;

m_strFilterpublic CString m_strFilter;

m_strRequeryFilterprotected CString m_strRequeryFilter;

m_strRequerySortprotected CString m_strRequerySort;

m_strRequerySQLprotected CString m_strRequerySQL;

m_strSortpublic CString m_strSort;

m_strSQLpublic CString m_strSQL;

Constructor Detail

CDaoRecordsetpublic CDaoRecordset( CDaoDatabase* pDatabase = NULL );

~CDaoRecordsetpublic virtual ~CDaoRecordset();

Method Detail

AddNewpublic virtual void AddNew();

AllocCacheprotected void AllocCache();

AllocDatabaseprotected void AllocDatabase();

BindFieldsprotected void BindFields();

BindParametersprotected void BindParameters();

BuildParameterListprotected void BuildParameterList();

BuildSelectListprotected void BuildSelectList();

BuildSQLprotected void BuildSQL();

CanAppendpublic BOOL CanAppend() const;

CanBookmarkpublic BOOL CanBookmark();

CancelUpdatepublic virtual void CancelUpdate();

CanRestartpublic BOOL CanRestart();

CanScrollpublic BOOL CanScroll() const;

CanTransactpublic BOOL CanTransact();

CanUpdatepublic BOOL CanUpdate() const;

ClearDirtyFieldStatuspublic void ClearDirtyFieldStatus( UINT nField );

ClearFieldStatusFlagspublic void ClearFieldStatusFlags();

ClearNullFieldStatuspublic void ClearNullFieldStatus( UINT nField );

Closepublic virtual void Close();

Deletepublic virtual void Delete();

DoFieldExchangepublic virtual void DoFieldExchange( CDaoFieldExchange* pFX );

Editpublic virtual void Edit();

FillCachepublic void FillCache( long* pSize = NULL, COleVariant* pBookmark = NULL );

Findpublic virtual BOOL Find( long lFindType, LPCTSTR lpszFilter );

FindFirstpublic BOOL FindFirst( LPCTSTR lpszFilter );

FindLastpublic BOOL FindLast( LPCTSTR lpszFilter );

FindNextpublic BOOL FindNext( LPCTSTR lpszFilter );

FindPrevpublic BOOL FindPrev( LPCTSTR lpszFilter );

Fixupprotected void Fixup();

FreeCacheprotected void FreeCache();

GetAbsolutePositionpublic long GetAbsolutePosition();

GetBookmarkpublic COleVariant GetBookmark();

GetCacheSizepublic long GetCacheSize();

GetCacheStartpublic COleVariant GetCacheStart();

GetCurrentIndexpublic CString GetCurrentIndex();

GetDataAndFixupNullspublic void GetDataAndFixupNulls();

GetDateCreatedpublic COleDateTime GetDateCreated();

GetDateLastUpdatedpublic COleDateTime GetDateLastUpdated();

GetDefaultDBNamepublic virtual CString GetDefaultDBName();

GetDefaultSQLpublic virtual CString GetDefaultSQL();

GetEditModepublic short GetEditMode();

GetFieldCountpublic short GetFieldCount();

GetFieldIndexprotected int GetFieldIndex( void* pv );

GetFieldInfopublic void GetFieldInfo( LPCTSTR lpszName, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 );

GetFieldInfopublic void GetFieldInfo( int nIndex, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 );

GetFieldLengthpublic DWORD GetFieldLength( int nFieldIndex );

GetFieldValuepublic virtual void GetFieldValue( LPCTSTR lpszName, COleVariant& varValue );

GetFieldValuepublic virtual void GetFieldValue( int nIndex, COleVariant& varValue );

GetFieldValuepublic virtual COleVariant GetFieldValue( LPCTSTR lpszName );

GetFieldValuepublic virtual COleVariant GetFieldValue( int nIndex );

GetIndexCountpublic short GetIndexCount();

GetIndexInfopublic void GetIndexInfo( int nIndex, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 );

GetIndexInfopublic void GetIndexInfo( LPCTSTR lpszName, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 );

GetLastModifiedBookmarkpublic COleVariant GetLastModifiedBookmark();

GetLockingModepublic BOOL GetLockingMode();

GetNamepublic CString GetName();

GetParamValuepublic virtual COleVariant GetParamValue( LPCTSTR lpszName );

GetParamValuepublic virtual COleVariant GetParamValue( int nIndex );

GetPercentPositionpublic float GetPercentPosition();

GetRecordCountpublic long GetRecordCount();

GetSQLpublic CString GetSQL() const;

GetTypepublic short GetType();

GetValidationRulepublic CString GetValidationRule();

GetValidationTextpublic CString GetValidationText();

InitFieldsCollectionprotected void InitFieldsCollection();

InitIndexesCollectionprotected void InitIndexesCollection();

IsBOFpublic BOOL IsBOF() const;

IsDeletedpublic BOOL IsDeleted() const;

IsEOFpublic BOOL IsEOF() const;

IsFieldDirtypublic BOOL IsFieldDirty( void* pv );

IsFieldNullpublic BOOL IsFieldNull( void* pv );

IsFieldNullablepublic BOOL IsFieldNullable( void* pv );

IsFieldStatusDirtypublic BOOL IsFieldStatusDirty( UINT nField );

IsFieldStatusNullpublic BOOL IsFieldStatusNull( UINT nField );

IsFieldStatusNullablepublic BOOL IsFieldStatusNullable( UINT nField );

IsFieldStatusNullableKnownpublic BOOL IsFieldStatusNullableKnown( UINT nField );

IsMatchpublic BOOL IsMatch();

IsOpenpublic BOOL IsOpen() const;

LoadFieldsprotected void LoadFields();

MarkForAddNewprotected void MarkForAddNew();

MarkForEditprotected void MarkForEdit();

Movepublic virtual void Move( long lRows );

MoveFirstpublic void MoveFirst();

MoveLastpublic void MoveLast();

MoveNextpublic void MoveNext();

MovePrevpublic void MovePrev();

Openpublic virtual void Open( CDaoQueryDef* pQueryDef, int nOpenType = dbOpenDynaset, int nOptions = 0 );

Openpublic virtual void Open( int nOpenType =(-1 L ), LPCTSTR lpszSQL = NULL, int nOptions = 0 );

Openpublic virtual void Open( CDaoTableDef* pTableDef, int nOpenType = dbOpenTable, int nOptions = 0 );

Requerypublic virtual void Requery();

Seekpublic BOOL Seek( LPCTSTR lpszComparison, COleVariant* pKey1, COleVariant* pKey2 = NULL, COleVariant* pKey3 = NULL );

Seekpublic BOOL Seek( LPCTSTR lpszComparison, COleVariant* pKeyArray, WORD nKeys );

SetAbsolutePositionpublic void SetAbsolutePosition( long lPosition );

SetBookmarkpublic void SetBookmark( COleVariant varBookmark );

SetCacheSizepublic void SetCacheSize( long lSize );

SetCacheStartpublic void SetCacheStart( COleVariant varBookmark );

SetCurrentIndexpublic void SetCurrentIndex( LPCTSTR lpszIndex );

SetCursorAttributespublic void SetCursorAttributes();

SetDirtyFieldsprotected virtual void SetDirtyFields();

SetDirtyFieldStatuspublic void SetDirtyFieldStatus( UINT nField );

SetFieldDirtypublic void SetFieldDirty( void* pv, BOOL bDirty = TRUE );

SetFieldNullpublic void SetFieldNull( void* pv, BOOL bNull = TRUE );

SetFieldValuepublic virtual void SetFieldValue( LPCTSTR lpszName, const COleVariant& varValue );

SetFieldValuepublic void SetFieldValue( int nIndex, LPCTSTR lpszValue );

SetFieldValuepublic void SetFieldValue( LPCTSTR lpszName, LPCTSTR lpszValue );

SetFieldValuepublic virtual void SetFieldValue( int nIndex, const COleVariant& varValue );

SetFieldValueNullpublic void SetFieldValueNull( int nIndex );

SetFieldValueNullpublic void SetFieldValueNull( LPCTSTR lpszName );

SetLockingModepublic void SetLockingMode( BOOL bPessimistic );

SetNullableFieldStatuspublic void SetNullableFieldStatus( UINT nField );

SetNullableKnownFieldStatuspublic void SetNullableKnownFieldStatus( UINT nField );

SetNullFieldStatuspublic void SetNullFieldStatus( UINT nField );

SetParamValuepublic virtual void SetParamValue( int nIndex, const COleVariant& varValue );

SetParamValuepublic virtual void SetParamValue( LPCTSTR lpszName, const COleVariant& varValue );

SetParamValueNullpublic void SetParamValueNull( LPCTSTR lpszName );

SetParamValueNullpublic void SetParamValueNull( int nIndex );

SetPercentPositionpublic void SetPercentPosition( float fPosition );

StoreFieldsprotected void StoreFields();

StripBracketspublic static void AFX_CDECL StripBrackets( LPCTSTR lpszSrc, LPTSTR lpszDest );

ThrowDaoExceptionprotected virtual void ThrowDaoException( int nError = 0 );

Updatepublic virtual void Update();

• 未来我们可以和性爱机器人结婚吗？
  探索
• 什么是脂肪粒？如何消除脸部脂肪粒？
  女性
• 五个症状提醒你免疫力在下降了
  健康
• 韩式辣椒酱爆伍丁(图)－西餐菜谱
  美食
• 国庆节搞笑祝福短信
  干货
• 女子体内爬出大量瓜子状活虫
  百态

• ·学会使用SafeArray
• ·饱腹食品VS致饿食品 怎么样吃得饱又不胖 减肥
• ·《QQ列表精灵》源代码分析！公布
• ·HTTP POST的文件上传问题
• ·SAP system fields
• ·MS SQL Server MFC DAO 类
• ·Java2下Applet数字签名具体实现方法
• ·新旧方法大PK，看好莱坞明星怎样保持好身材？
• ·“自慰”者的游戏------评[呼联网周刊]2
• ·关于社会性软件、IM和p2p等的随想