MFC
Class CDaoRecordset
CObject
|
+--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_bAppendable
protected BOOL m_bAppendable;
m_bCheckCacheForDirtyFields
public BOOL m_bCheckCacheForDirtyFields;
m_bDeleted
protected BOOL m_bDeleted;
m_bOpen
protected BOOL m_bOpen;
m_bScrollable
protected BOOL m_bScrollable;
m_cbFixedLengthFields
public DWORD m_cbFixedLengthFields;
m_DaoFetchRows
public DAOFETCHROWS m_DaoFetchRows;
m_nDefaultType
protected int m_nDefaultType;
m_nFields
public int m_nFields;
m_nOpenType
protected int m_nOpenType;
m_nOptions
protected int m_nOptions;
m_nParams
public int m_nParams;
m_nStatus
protected int m_nStatus;
m_pbFieldFlags
public BYTE* m_pbFieldFlags;
m_pbParamFlags
public BYTE* m_pbParamFlags;
m_pDAOFields
public DAOFields* m_pDAOFields;
m_pDAOIndexes
public DAOIndexes* m_pDAOIndexes;
m_pDAORecordset
public DAORecordset* m_pDAORecordset;
m_pDatabase
public CDaoDatabase* m_pDatabase;
m_pICDAORecordsetGetRows
public ICDAORecordset* m_pICDAORecordsetGetRows;
m_pMapFieldCache
public CMapPtrToPtr* m_pMapFieldCache;
m_pMapFieldIndex
public CMapPtrToPtr* m_pMapFieldIndex;
m_pQueryDef
public CDaoQueryDef* m_pQueryDef;
m_prgDaoColBindInfo
public DAOCOLUMNBINDING* m_prgDaoColBindInfo;
m_pTableDef
public CDaoTableDef* m_pTableDef;
m_pulColumnLengths
public DWORD* m_pulColumnLengths;
m_strFilter
public CString m_strFilter;
m_strRequeryFilter
protected CString m_strRequeryFilter;
m_strRequerySort
protected CString m_strRequerySort;
m_strRequerySQL
protected CString m_strRequerySQL;
m_strSort
public CString m_strSort;
m_strSQL
public CString m_strSQL;
CDaoRecordset
public CDaoRecordset( CDaoDatabase* pDatabase = NULL );
~CDaoRecordset
public virtual ~CDaoRecordset();
AddNew
public virtual void AddNew();
AllocCache
protected void AllocCache();
AllocDatabase
protected void AllocDatabase();
BindFields
protected void BindFields();
BindParameters
protected void BindParameters();
BuildParameterList
protected void BuildParameterList();
BuildSelectList
protected void BuildSelectList();
BuildSQL
protected void BuildSQL();
CanAppend
public BOOL CanAppend() const;
CanBookmark
public BOOL CanBookmark();
CancelUpdate
public virtual void CancelUpdate();
CanRestart
public BOOL CanRestart();
CanScroll
public BOOL CanScroll() const;
CanTransact
public BOOL CanTransact();
CanUpdate
public BOOL CanUpdate() const;
ClearDirtyFieldStatus
public void ClearDirtyFieldStatus( UINT nField );
ClearFieldStatusFlags
public void ClearFieldStatusFlags();
ClearNullFieldStatus
public void ClearNullFieldStatus( UINT nField );
Close
public virtual void Close();
Delete
public virtual void Delete();
DoFieldExchange
public virtual void DoFieldExchange( CDaoFieldExchange* pFX );
Edit
public virtual void Edit();
FillCache
public void FillCache( long* pSize = NULL, COleVariant* pBookmark = NULL );
Find
public virtual BOOL Find( long lFindType, LPCTSTR lpszFilter );
FindFirst
public BOOL FindFirst( LPCTSTR lpszFilter );
FindLast
public BOOL FindLast( LPCTSTR lpszFilter );
FindNext
public BOOL FindNext( LPCTSTR lpszFilter );
FindPrev
public BOOL FindPrev( LPCTSTR lpszFilter );
Fixup
protected void Fixup();
FreeCache
protected void FreeCache();
GetAbsolutePosition
public long GetAbsolutePosition();
GetBookmark
public COleVariant GetBookmark();
GetCacheSize
public long GetCacheSize();
GetCacheStart
public COleVariant GetCacheStart();
GetCurrentIndex
public CString GetCurrentIndex();
GetDataAndFixupNulls
public void GetDataAndFixupNulls();
GetDateCreated
public COleDateTime GetDateCreated();
GetDateLastUpdated
public COleDateTime GetDateLastUpdated();
GetDefaultDBName
public virtual CString GetDefaultDBName();
GetDefaultSQL
public virtual CString GetDefaultSQL();
GetEditMode
public short GetEditMode();
GetFieldCount
public short GetFieldCount();
GetFieldIndex
protected int GetFieldIndex( void* pv );
GetFieldInfo
public void GetFieldInfo( LPCTSTR lpszName, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 );
GetFieldInfo
public void GetFieldInfo( int nIndex, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 );
GetFieldLength
public DWORD GetFieldLength( int nFieldIndex );
GetFieldValue
public virtual void GetFieldValue( LPCTSTR lpszName, COleVariant& varValue );
GetFieldValue
public virtual void GetFieldValue( int nIndex, COleVariant& varValue );
GetFieldValue
public virtual COleVariant GetFieldValue( LPCTSTR lpszName );
GetFieldValue
public virtual COleVariant GetFieldValue( int nIndex );
GetIndexCount
public short GetIndexCount();
GetIndexInfo
public void GetIndexInfo( int nIndex, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 );
GetIndexInfo
public void GetIndexInfo( LPCTSTR lpszName, CDaoIndexInfo& indexinfo, DWORD dwInfoOptions = 0x00000001 );
GetLastModifiedBookmark
public COleVariant GetLastModifiedBookmark();
GetLockingMode
public BOOL GetLockingMode();
GetName
public CString GetName();
GetParamValue
public virtual COleVariant GetParamValue( LPCTSTR lpszName );
GetParamValue
public virtual COleVariant GetParamValue( int nIndex );
GetPercentPosition
public float GetPercentPosition();
GetRecordCount
public long GetRecordCount();
GetSQL
public CString GetSQL() const;
GetType
public short GetType();
GetValidationRule
public CString GetValidationRule();
GetValidationText
public CString GetValidationText();
InitFieldsCollection
protected void InitFieldsCollection();
InitIndexesCollection
protected void InitIndexesCollection();
IsBOF
public BOOL IsBOF() const;
IsDeleted
public BOOL IsDeleted() const;
IsEOF
public BOOL IsEOF() const;
IsFieldDirty
public BOOL IsFieldDirty( void* pv );
IsFieldNull
public BOOL IsFieldNull( void* pv );
IsFieldNullable
public BOOL IsFieldNullable( void* pv );
IsFieldStatusDirty
public BOOL IsFieldStatusDirty( UINT nField );
IsFieldStatusNull
public BOOL IsFieldStatusNull( UINT nField );
IsFieldStatusNullable
public BOOL IsFieldStatusNullable( UINT nField );
IsFieldStatusNullableKnown
public BOOL IsFieldStatusNullableKnown( UINT nField );
IsMatch
public BOOL IsMatch();
IsOpen
public BOOL IsOpen() const;
LoadFields
protected void LoadFields();
MarkForAddNew
protected void MarkForAddNew();
MarkForEdit
protected void MarkForEdit();
Move
public virtual void Move( long lRows );
MoveFirst
public void MoveFirst();
MoveLast
public void MoveLast();
MoveNext
public void MoveNext();
MovePrev
public void MovePrev();
Open
public virtual void Open( CDaoQueryDef* pQueryDef, int nOpenType = dbOpenDynaset, int nOptions = 0 );
Open
public virtual void Open( int nOpenType =(-1 L ), LPCTSTR lpszSQL = NULL, int nOptions = 0 );
Open
public virtual void Open( CDaoTableDef* pTableDef, int nOpenType = dbOpenTable, int nOptions = 0 );
Requery
public virtual void Requery();
Seek
public BOOL Seek( LPCTSTR lpszComparison, COleVariant* pKey1, COleVariant* pKey2 = NULL, COleVariant* pKey3 = NULL );
Seek
public BOOL Seek( LPCTSTR lpszComparison, COleVariant* pKeyArray, WORD nKeys );
SetAbsolutePosition
public void SetAbsolutePosition( long lPosition );
SetBookmark
public void SetBookmark( COleVariant varBookmark );
SetCacheSize
public void SetCacheSize( long lSize );
SetCacheStart
public void SetCacheStart( COleVariant varBookmark );
SetCurrentIndex
public void SetCurrentIndex( LPCTSTR lpszIndex );
SetCursorAttributes
public void SetCursorAttributes();
SetDirtyFields
protected virtual void SetDirtyFields();
SetDirtyFieldStatus
public void SetDirtyFieldStatus( UINT nField );
SetFieldDirty
public void SetFieldDirty( void* pv, BOOL bDirty = TRUE );
SetFieldNull
public void SetFieldNull( void* pv, BOOL bNull = TRUE );
SetFieldValue
public virtual void SetFieldValue( LPCTSTR lpszName, const COleVariant& varValue );
SetFieldValue
public void SetFieldValue( int nIndex, LPCTSTR lpszValue );
SetFieldValue
public void SetFieldValue( LPCTSTR lpszName, LPCTSTR lpszValue );
SetFieldValue
public virtual void SetFieldValue( int nIndex, const COleVariant& varValue );
SetFieldValueNull
public void SetFieldValueNull( int nIndex );
SetFieldValueNull
public void SetFieldValueNull( LPCTSTR lpszName );
SetLockingMode
public void SetLockingMode( BOOL bPessimistic );
SetNullableFieldStatus
public void SetNullableFieldStatus( UINT nField );
SetNullableKnownFieldStatus
public void SetNullableKnownFieldStatus( UINT nField );
SetNullFieldStatus
public void SetNullFieldStatus( UINT nField );
SetParamValue
public virtual void SetParamValue( int nIndex, const COleVariant& varValue );
SetParamValue
public virtual void SetParamValue( LPCTSTR lpszName, const COleVariant& varValue );
SetParamValueNull
public void SetParamValueNull( LPCTSTR lpszName );
SetParamValueNull
public void SetParamValueNull( int nIndex );
SetPercentPosition
public void SetPercentPosition( float fPosition );
StoreFields
protected void StoreFields();
StripBrackets
public static void AFX_CDECL StripBrackets( LPCTSTR lpszSrc, LPTSTR lpszDest );
ThrowDaoException
protected virtual void ThrowDaoException( int nError = 0 );
Update
public virtual void Update();