MFC
Class CRecordset
CObject
|
+--CRecordset
in AFXDB.H
- class CRecordset
- extends CObject
CRecordset - the result of a SQL Statement
|
Method Summary |
virtual void |
AddNew()
|
protected void |
AllocAndCacheFieldInfo()
|
void |
AllocDataCache()
|
protected BOOL |
AllocHstmt()
|
protected void |
AllocRowset()
|
void |
AllocStatusArrays()
|
protected void |
AppendFilterAndSortSQL()
|
UINT |
AppendNames( CString* pstr, LPCTSTR szSeparator )
|
UINT |
AppendNamesValues( HSTMT hstmt, CString* pstr, LPCTSTR szSeparator )
|
UINT |
AppendValues( HSTMT hstmt, CString* pstr, LPCTSTR szSeparator )
|
void |
BindFieldsForUpdate()
|
UINT |
BindFieldsToColumns()
|
UINT |
BindParams( HSTMT hstmt )
|
protected void |
BuildSelectSQL()
|
protected void |
BuildSQL( LPCTSTR lpszSQL )
|
protected void |
BuildUpdateSQL()
|
BOOL |
CanAppend() const
|
BOOL |
CanBookmark() const
|
void |
Cancel()
|
void |
CancelUpdate()
|
BOOL |
CanRestart() const
|
BOOL |
CanScroll() const
|
BOOL |
CanTransact() const
|
BOOL |
CanUpdate() const
|
virtual BOOL |
Check( RETCODE nRetCode ) const
|
void |
CheckRowsetCurrencyStatus( UWORD wFetchType, long nRows )
|
virtual void |
CheckRowsetError( RETCODE nRetCode )
|
void |
ClearDirtyFieldStatus( DWORD nField )
|
void |
ClearFieldStatus()
|
void |
ClearNullFieldStatus( DWORD nField )
|
void |
ClearNullParamStatus( DWORD nField )
|
virtual void |
Close()
|
virtual void |
Delete()
|
virtual void |
DoBulkFieldExchange( CFieldExchange* pFX )
|
virtual void |
DoFieldExchange( CFieldExchange* pFX )
|
virtual void |
Edit()
|
protected void |
EnableBookmarks()
|
protected void |
ExecuteSetPosUpdate()
|
protected void |
ExecuteUpdateSQL()
|
RETCODE |
FetchData( UWORD wFetchType, SDWORD nRow, DWORD* pdwRowsFetched )
|
static LPCTSTR PASCAL |
FindSQLToken( LPCTSTR lpszSQL, LPCTSTR lpszSQLToken )
|
void |
Fixups()
|
BOOL |
FlushResultSet() const
|
void |
FreeDataCache()
|
protected void |
FreeRowset()
|
void |
GetBookmark( CDBVariant& varBookmark )
|
int |
GetBoundFieldIndex( void* pv )
|
int |
GetBoundParamIndex( void* pv )
|
static long PASCAL |
GetData( CDatabase* pdb, HSTMT hstmt, short nFieldIndex, short nFieldType, LPVOID pvData, int nLen, short nSQLType )
|
static void* PASCAL |
GetDataBuffer( CDBVariant& varValue, short nFieldType, int* pnLen, short nSQLType, UDWORD nPrecision )
|
virtual CString |
GetDefaultConnect()
|
static short PASCAL |
GetDefaultFieldType( short nSQLType )
|
virtual CString |
GetDefaultSQL()
|
short |
GetFieldIndexByName( LPCTSTR lpszFieldName )
|
long* |
GetFieldLengthBuffer( DWORD nField, int nFieldType )
|
BYTE |
GetFieldStatus( DWORD nField )
|
void |
GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = SQL_TYPE_NULL )
|
void |
GetFieldValue( short nIndex, CDBVariant& varValue, short nFieldType = SQL_TYPE_NULL )
|
void |
GetFieldValue( short nIndex, CString& strValue )
|
void |
GetFieldValue( LPCTSTR lpszName, CString& strValue )
|
protected virtual long |
GetLBFetchSize( long lOldSize )
|
protected virtual long |
GetLBReallocSize( long lOldSize )
|
static void PASCAL |
GetLongBinaryDataAndCleanup( CDatabase* pdb, HSTMT hstmt, short nFieldIndex, long nActualSize, LPVOID* ppvData, int nLen, CDBVariant& varValue, short nSQLType )
|
static void PASCAL |
GetLongCharDataAndCleanup( CDatabase* pdb, HSTMT hstmt, short nFieldIndex, long nActualSize, LPVOID* ppvData, int nLen, CString& strValue, short nSQLType )
|
short |
GetODBCFieldCount() const
|
void |
GetODBCFieldInfo( short nIndex, CODBCFieldInfo& fieldinfo )
|
void |
GetODBCFieldInfo( LPCTSTR lpszName, CODBCFieldInfo& fieldinfo )
|
long |
GetRecordCount() const
|
DWORD |
GetRowsetSize() const
|
DWORD |
GetRowsFetched() const
|
WORD |
GetRowStatus( WORD wRow ) const
|
const CString& |
GetSQL() const
|
void |
GetStatus( CRecordsetStatus& rStatus ) const
|
const CString& |
GetTableName() const
|
static int PASCAL |
GetTextLen( short nSQLType, UDWORD nPrecision )
|
void |
InitRecord()
|
BOOL |
IsBOF() const
|
BOOL |
IsDeleted() const
|
BOOL |
IsEOF() const
|
BOOL |
IsFieldDirty( void* pv )
|
BOOL |
IsFieldNull( void* pv )
|
BOOL |
IsFieldNullable( void* pv )
|
BOOL |
IsFieldNullable( DWORD nField ) const
|
BOOL |
IsFieldStatusDirty( DWORD nField ) const
|
BOOL |
IsFieldStatusNull( DWORD nField ) const
|
static BOOL PASCAL |
IsJoin( LPCTSTR lpszJoinClause )
|
BOOL |
IsOpen() const
|
BOOL |
IsParamStatusNull( DWORD nField ) const
|
protected BOOL |
IsRecordsetUpdatable()
|
BOOL |
IsSelectQueryUpdatable( LPCTSTR lpszSQL )
|
BOOL |
IsSQLUpdatable( LPCTSTR lpszSQL )
|
void |
LoadFields()
|
void |
MarkForAddNew()
|
void |
MarkForUpdate()
|
virtual void |
Move( long nRows, WORD wFetchType = SQL_FETCH_RELATIVE )
|
void |
MoveFirst()
|
void |
MoveLast()
|
void |
MoveNext()
|
void |
MovePrev()
|
virtual void |
OnSetOptions( HSTMT hstmt )
|
virtual BOOL |
Open( UINT nOpenType =( 0xFFFFFFFF ), LPCTSTR lpszSQL = NULL, DWORD dwOptions = none )
|
virtual void |
PreBindFields()
|
protected void |
PrepareAndExecute()
|
protected void |
PrepareUpdateHstmt()
|
void |
RebindParams( HSTMT hstmt )
|
void |
RefreshRowset( WORD wRow, WORD wLockType = SQL_LOCK_NO_CHANGE )
|
virtual BOOL |
Requery()
|
void |
ResetCursor()
|
protected void |
SendLongBinaryData( HSTMT hstmt )
|
void |
SetAbsolutePosition( long nRows )
|
void |
SetBookmark( const CDBVariant& varBookmark )
|
protected void |
SetConcurrencyAndCursorType( HSTMT hstmt, DWORD dwScrollOptions )
|
void |
SetDirtyFieldStatus( DWORD nField )
|
void |
SetFieldDirty( void* pv, BOOL bDirty = TRUE )
|
void |
SetFieldNull( void* pv, BOOL bNull = TRUE )
|
void |
SetFieldStatus( DWORD nField, BYTE bFlags )
|
void |
SetLockingMode( UINT nMode )
|
void |
SetNullFieldStatus( DWORD nField )
|
void |
SetNullParamStatus( DWORD nField )
|
void |
SetParamNull( int nIndex, BOOL bNull = TRUE )
|
virtual void |
SetRowsetCurrencyStatus( RETCODE nRetCode, UWORD wFetchType, long nRows, DWORD dwRowsFetched )
|
void |
SetRowsetCursorPosition( WORD wRow, WORD wLockType = SQL_LOCK_NO_CHANGE )
|
virtual void |
SetRowsetSize( DWORD dwNewRowsetSize )
|
protected void |
SetState( int nOpenType, LPCTSTR lpszSQL, DWORD dwOptions )
|
protected void |
SetUpdateMethod()
|
void |
SkipDeletedRecords( UWORD wFetchType, long nRows, DWORD* pdwRowsFetched, RETCODE* pnRetCode )
|
void |
StoreFields()
|
virtual void |
ThrowDBException( RETCODE nRetCode, HSTMT hstmt = SQL_NULL_HSTMT )
|
void |
UnbindFieldsForUpdate()
|
virtual BOOL |
Update()
|
protected BOOL |
UpdateInsertDelete()
|
protected DWORD |
VerifyCursorSupport()
|
protected void |
VerifyDriverBehavior()
|
m_bAppendable
protected BOOL m_bAppendable;
m_bBOF
protected BOOL m_bBOF;
m_bCheckCacheForDirtyFields
public BOOL m_bCheckCacheForDirtyFields;
m_bDeleted
protected BOOL m_bDeleted;
m_bEOF
protected BOOL m_bEOF;
m_bEOFSeen
protected BOOL m_bEOFSeen;
m_bLongBinaryColumns
public BOOL m_bLongBinaryColumns;
m_bRebindParams
public BOOL m_bRebindParams;
m_bRecordsetDb
protected BOOL m_bRecordsetDb;
m_bScrollable
protected BOOL m_bScrollable;
m_bUpdatable
protected BOOL m_bUpdatable;
m_bUseODBCCursorLib
public BOOL m_bUseODBCCursorLib;
m_bUseUpdateSQL
public BOOL m_bUseUpdateSQL;
m_dwAllocatedRowsetSize
protected DWORD m_dwAllocatedRowsetSize;
m_dwConcurrency
protected UDWORD m_dwConcurrency;
m_dwDriverConcurrency
protected UDWORD m_dwDriverConcurrency;
m_dwInitialGetDataLen
protected DWORD m_dwInitialGetDataLen;
m_dwOptions
public DWORD m_dwOptions;
m_dwRowsetSize
protected DWORD m_dwRowsetSize;
m_dwRowsFetched
protected DWORD m_dwRowsFetched;
m_hstmt
public HSTMT m_hstmt;
m_hstmtUpdate
protected HSTMT m_hstmtUpdate;
m_lCurrentRecord
protected long m_lCurrentRecord;
m_lOpen
protected long m_lOpen;
m_lRecordCount
protected long m_lRecordCount;
m_mapFieldIndex
public CMapPtrToPtr m_mapFieldIndex;
m_mapParamIndex
public CMapPtrToPtr m_mapParamIndex;
m_nDefaultType
protected UINT m_nDefaultType;
m_nEditMode
protected UINT m_nEditMode;
m_nFields
public UINT m_nFields;
m_nFieldsBound
protected int m_nFieldsBound;
m_nLockMode
protected BOOL m_nLockMode;
m_nOpenType
protected UINT m_nOpenType;
m_nParams
public UINT m_nParams;
m_nProxyFields
public UINT m_nProxyFields;
m_nProxyParams
public UINT m_nProxyParams;
m_nResultCols
public SWORD m_nResultCols;
m_pbFieldFlags
protected BYTE* m_pbFieldFlags;
m_pbParamFlags
protected BYTE* m_pbParamFlags;
m_pDatabase
public CDatabase* m_pDatabase;
m_plParamLength
protected LONG* m_plParamLength;
m_pvFieldProxy
public void** m_pvFieldProxy;
m_pvParamProxy
public void** m_pvParamProxy;
m_rgFieldInfos
public CFieldInfo* m_rgFieldInfos;
m_rgODBCFieldInfos
public CODBCFieldInfo* m_rgODBCFieldInfos;
m_rgRowStatus
protected UWORD* m_rgRowStatus;
m_strCursorName
protected CString m_strCursorName;
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
protected CString m_strSQL;
m_strTableName
protected CString m_strTableName;
m_strUpdateSQL
protected CString m_strUpdateSQL;
CRecordset
public CRecordset( CDatabase* pDatabase = NULL );
~CRecordset
public virtual ~CRecordset();
AddNew
public virtual void AddNew();
AllocAndCacheFieldInfo
protected void AllocAndCacheFieldInfo();
AllocDataCache
public void AllocDataCache();
AllocHstmt
protected BOOL AllocHstmt();
AllocRowset
protected void AllocRowset();
AllocStatusArrays
public void AllocStatusArrays();
AppendFilterAndSortSQL
protected void AppendFilterAndSortSQL();
AppendNames
public UINT AppendNames( CString* pstr, LPCTSTR szSeparator );
AppendNamesValues
public UINT AppendNamesValues( HSTMT hstmt, CString* pstr, LPCTSTR szSeparator );
AppendValues
public UINT AppendValues( HSTMT hstmt, CString* pstr, LPCTSTR szSeparator );
BindFieldsForUpdate
public void BindFieldsForUpdate();
BindFieldsToColumns
public UINT BindFieldsToColumns();
BindParams
public UINT BindParams( HSTMT hstmt );
BuildSelectSQL
protected void BuildSelectSQL();
BuildSQL
protected void BuildSQL( LPCTSTR lpszSQL );
BuildUpdateSQL
protected void BuildUpdateSQL();
CanAppend
public BOOL CanAppend() const;
CanBookmark
public BOOL CanBookmark() const;
Cancel
public void Cancel();
CancelUpdate
public void CancelUpdate();
CanRestart
public BOOL CanRestart() const;
CanScroll
public BOOL CanScroll() const;
CanTransact
public BOOL CanTransact() const;
CanUpdate
public BOOL CanUpdate() const;
Check
public virtual BOOL Check( RETCODE nRetCode ) const;
CheckRowsetCurrencyStatus
public void CheckRowsetCurrencyStatus( UWORD wFetchType, long nRows );
CheckRowsetError
public virtual void CheckRowsetError( RETCODE nRetCode );
ClearDirtyFieldStatus
public void ClearDirtyFieldStatus( DWORD nField );
ClearFieldStatus
public void ClearFieldStatus();
ClearNullFieldStatus
public void ClearNullFieldStatus( DWORD nField );
ClearNullParamStatus
public void ClearNullParamStatus( DWORD nField );
Close
public virtual void Close();
Delete
public virtual void Delete();
DoBulkFieldExchange
public virtual void DoBulkFieldExchange( CFieldExchange* pFX );
DoFieldExchange
public virtual void DoFieldExchange( CFieldExchange* pFX );
Edit
public virtual void Edit();
EnableBookmarks
protected void EnableBookmarks();
ExecuteSetPosUpdate
protected void ExecuteSetPosUpdate();
ExecuteUpdateSQL
protected void ExecuteUpdateSQL();
FetchData
public RETCODE FetchData( UWORD wFetchType, SDWORD nRow, DWORD* pdwRowsFetched );
FindSQLToken
public static LPCTSTR PASCAL FindSQLToken( LPCTSTR lpszSQL, LPCTSTR lpszSQLToken );
Fixups
public void Fixups();
FlushResultSet
public BOOL FlushResultSet() const;
FreeDataCache
public void FreeDataCache();
FreeRowset
protected void FreeRowset();
GetBookmark
public void GetBookmark( CDBVariant& varBookmark );
GetBoundFieldIndex
public int GetBoundFieldIndex( void* pv );
GetBoundParamIndex
public int GetBoundParamIndex( void* pv );
GetData
public static long PASCAL GetData( CDatabase* pdb, HSTMT hstmt, short nFieldIndex, short nFieldType, LPVOID pvData, int nLen, short nSQLType );
GetDataBuffer
public static void* PASCAL GetDataBuffer( CDBVariant& varValue, short nFieldType, int* pnLen, short nSQLType, UDWORD nPrecision );
GetDefaultConnect
public virtual CString GetDefaultConnect();
GetDefaultFieldType
public static short PASCAL GetDefaultFieldType( short nSQLType );
GetDefaultSQL
public virtual CString GetDefaultSQL();
GetFieldIndexByName
public short GetFieldIndexByName( LPCTSTR lpszFieldName );
GetFieldLengthBuffer
public long* GetFieldLengthBuffer( DWORD nField, int nFieldType );
GetFieldStatus
public BYTE GetFieldStatus( DWORD nField );
GetFieldValue
public void GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = SQL_TYPE_NULL );
GetFieldValue
public void GetFieldValue( short nIndex, CDBVariant& varValue, short nFieldType = SQL_TYPE_NULL );
GetFieldValue
public void GetFieldValue( short nIndex, CString& strValue );
GetFieldValue
public void GetFieldValue( LPCTSTR lpszName, CString& strValue );
GetLBFetchSize
protected virtual long GetLBFetchSize( long lOldSize );
GetLBReallocSize
protected virtual long GetLBReallocSize( long lOldSize );
GetLongBinaryDataAndCleanup
public static void PASCAL GetLongBinaryDataAndCleanup( CDatabase* pdb, HSTMT hstmt, short nFieldIndex, long nActualSize, LPVOID* ppvData, int nLen, CDBVariant& varValue, short nSQLType );
GetLongCharDataAndCleanup
public static void PASCAL GetLongCharDataAndCleanup( CDatabase* pdb, HSTMT hstmt, short nFieldIndex, long nActualSize, LPVOID* ppvData, int nLen, CString& strValue, short nSQLType );
GetODBCFieldCount
public short GetODBCFieldCount() const;
GetODBCFieldInfo
public void GetODBCFieldInfo( short nIndex, CODBCFieldInfo& fieldinfo );
GetODBCFieldInfo
public void GetODBCFieldInfo( LPCTSTR lpszName, CODBCFieldInfo& fieldinfo );
GetRecordCount
public long GetRecordCount() const;
GetRowsetSize
public DWORD GetRowsetSize() const;
GetRowsFetched
public DWORD GetRowsFetched() const;
GetRowStatus
public WORD GetRowStatus( WORD wRow ) const;
GetSQL
public const CString& GetSQL() const;
GetStatus
public void GetStatus( CRecordsetStatus& rStatus ) const;
GetTableName
public const CString& GetTableName() const;
GetTextLen
public static int PASCAL GetTextLen( short nSQLType, UDWORD nPrecision );
InitRecord
public void InitRecord();
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 );
IsFieldNullable
public BOOL IsFieldNullable( DWORD nField ) const;
IsFieldStatusDirty
public BOOL IsFieldStatusDirty( DWORD nField ) const;
IsFieldStatusNull
public BOOL IsFieldStatusNull( DWORD nField ) const;
IsJoin
public static BOOL PASCAL IsJoin( LPCTSTR lpszJoinClause );
IsOpen
public BOOL IsOpen() const;
IsParamStatusNull
public BOOL IsParamStatusNull( DWORD nField ) const;
IsRecordsetUpdatable
protected BOOL IsRecordsetUpdatable();
IsSelectQueryUpdatable
public BOOL IsSelectQueryUpdatable( LPCTSTR lpszSQL );
IsSQLUpdatable
public BOOL IsSQLUpdatable( LPCTSTR lpszSQL );
LoadFields
public void LoadFields();
MarkForAddNew
public void MarkForAddNew();
MarkForUpdate
public void MarkForUpdate();
Move
public virtual void Move( long nRows, WORD wFetchType = SQL_FETCH_RELATIVE );
MoveFirst
public void MoveFirst();
MoveLast
public void MoveLast();
MoveNext
public void MoveNext();
MovePrev
public void MovePrev();
OnSetOptions
public virtual void OnSetOptions( HSTMT hstmt );
Open
public virtual BOOL Open( UINT nOpenType =( 0xFFFFFFFF ), LPCTSTR lpszSQL = NULL, DWORD dwOptions = none );
PreBindFields
public virtual void PreBindFields();
PrepareAndExecute
protected void PrepareAndExecute();
PrepareUpdateHstmt
protected void PrepareUpdateHstmt();
RebindParams
public void RebindParams( HSTMT hstmt );
RefreshRowset
public void RefreshRowset( WORD wRow, WORD wLockType = SQL_LOCK_NO_CHANGE );
Requery
public virtual BOOL Requery();
ResetCursor
public void ResetCursor();
SendLongBinaryData
protected void SendLongBinaryData( HSTMT hstmt );
SetAbsolutePosition
public void SetAbsolutePosition( long nRows );
SetBookmark
public void SetBookmark( const CDBVariant& varBookmark );
SetConcurrencyAndCursorType
protected void SetConcurrencyAndCursorType( HSTMT hstmt, DWORD dwScrollOptions );
SetDirtyFieldStatus
public void SetDirtyFieldStatus( DWORD nField );
SetFieldDirty
public void SetFieldDirty( void* pv, BOOL bDirty = TRUE );
SetFieldNull
public void SetFieldNull( void* pv, BOOL bNull = TRUE );
SetFieldStatus
public void SetFieldStatus( DWORD nField, BYTE bFlags );
SetLockingMode
public void SetLockingMode( UINT nMode );
SetNullFieldStatus
public void SetNullFieldStatus( DWORD nField );
SetNullParamStatus
public void SetNullParamStatus( DWORD nField );
SetParamNull
public void SetParamNull( int nIndex, BOOL bNull = TRUE );
SetRowsetCurrencyStatus
public virtual void SetRowsetCurrencyStatus( RETCODE nRetCode, UWORD wFetchType, long nRows, DWORD dwRowsFetched );
SetRowsetCursorPosition
public void SetRowsetCursorPosition( WORD wRow, WORD wLockType = SQL_LOCK_NO_CHANGE );
SetRowsetSize
public virtual void SetRowsetSize( DWORD dwNewRowsetSize );
SetState
protected void SetState( int nOpenType, LPCTSTR lpszSQL, DWORD dwOptions );
SetUpdateMethod
protected void SetUpdateMethod();
SkipDeletedRecords
public void SkipDeletedRecords( UWORD wFetchType, long nRows, DWORD* pdwRowsFetched, RETCODE* pnRetCode );
StoreFields
public void StoreFields();
ThrowDBException
public virtual void ThrowDBException( RETCODE nRetCode, HSTMT hstmt = SQL_NULL_HSTMT );
UnbindFieldsForUpdate
public void UnbindFieldsForUpdate();
Update
public virtual BOOL Update();
UpdateInsertDelete
protected BOOL UpdateInsertDelete();
VerifyCursorSupport
protected DWORD VerifyCursorSupport();
VerifyDriverBehavior
protected void VerifyDriverBehavior();