其他语言

本类阅读TOP10

·基于Solaris 开发环境的整体构思
·使用AutoMake轻松生成Makefile
·BCB数据库图像保存技术
·GNU中的Makefile
·射频芯片nRF401天线设计的分析
·iframe 的自适应高度
·BCB之Socket通信
·软件企业如何实施CMM
·入门系列--OpenGL最简单的入门
·WIN95中日志钩子(JournalRecord Hook)的使用

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
Class CDaoRecordset

作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站

Class CDaoRecordset
CObject
   |
   +--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_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;


Constructor Detail

CDaoRecordset

public CDaoRecordset( CDaoDatabase* pDatabase = NULL );

~CDaoRecordset

public virtual ~CDaoRecordset();


Method Detail

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();



相关文章

相关软件