Class CDaoRecordsetCObject
|
+--CDaoRecordset
in AFXDAO.H
class CDaoRecordset
extends CObject
CDaoRecordset - the result of a query or base table browse
Field Summary
protected BOOL
BOOL
protected BOOL
protected BOOL
protected BOOL
DWORD
DAOFETCHROWS
protected int
int
protected int
protected int
int
protected int
BYTE*
BYTE*
DAOFields*
DAOIndexes*
DAORecordset*
ICDAORecordset*
DAOCOLUMNBINDING*
DWORD*
protected CString
protected CString
protected CString
Fields inherited from class CObject
Constructor Summary
CDaoRecordset( CDaoDatabase* pDatabase = NULL )
virtual ~CDaoRecordset()
Method Summary
virtual void
AddNew()
protected void
protected void
protected void
protected void
protected void
protected void
protected void
BuildSQL()
BOOL
CanAppend() const
BOOL
virtual void
BOOL
BOOL
CanScroll() const
BOOL
BOOL
CanUpdate() const
void
ClearDirtyFieldStatus( UINT nField )
void
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
long
long
void
virtual CString
virtual CString
short
short
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
void
GetIndexInfo( int nIndex, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 )
void
GetIndexInfo( LPCTSTR lpszName, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 )
BOOL
GetName()
virtual COleVariant
GetParamValue( LPCTSTR lpszName )
virtual COleVariant
GetParamValue( int nIndex )
float
long
GetSQL() const
short
GetType()
protected void
protected void
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
protected void
protected void
virtual void
Move( long lRows )
void
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
protected virtual void
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
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();
