Class CDaoRecordsetCObject
|
+--CDaoRecordset
in AFXDAO.H
- class CDaoRecordset
- extends CObject
CDaoRecordset - the result of a query or base table browse
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() |
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;
CDaoRecordsetpublic CDaoRecordset( CDaoDatabase* pDatabase = NULL );
~CDaoRecordsetpublic virtual ~CDaoRecordset();
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();

|