MFC Documentation

home download screen shots bugs mailing list example output generated MFC docs help tools and utilities

Overview

Project

Class

Tree

Index

MFC Class Library

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

MFC
Class CDatabase

CObject
   |
   +--CDatabase

in AFXDB.H

class CDatabase
extends CObject

CDatabase - a SQL Database

Inner Classes, Typedefs, and Enums
`enum`	`CDatabase::DbOpenOptions`

Field Summary
`BOOL`	`m_bAddForUpdate`
`BOOL`	`m_bIncRecordCountOnAdd`
`BOOL`	`m_bStripTrailingSpaces`
`protected BOOL`	`m_bTransactions`
`protected BOOL`	`m_bUpdatable`
`char`	`m_chIDQuoteChar`
`protected DWORD`	`m_dwBookmarkAttributes`
`protected DWORD`	`m_dwLoginTimeout`
`protected DWORD`	`m_dwQueryTimeout`
`protected DWORD`	`m_dwUpdateOptions`
`HDBC`	`m_hdbc`
`protected HSTMT`	`m_hstmt`
`protected CPtrList`	`m_listRecordsets`
`protected SWORD`	`m_nCursorCommitBehavior`
`protected SWORD`	`m_nCursorRollbackBehavior`
`protected SWORD`	`m_nTransactionCapable`
`char[ 3 ]`	`m_reserved1`
`protected CString`	`m_strConnect`
`protected int`	`nRefCount`

Fields inherited from class CObject

classCObject

Constructor Summary
`CDatabase()`
`virtual ~CDatabase()`

Method Summary
`protected void`	`AllocConnect( DWORD dwOptions )`
`BOOL`	`BeginTrans()`
`virtual void`	`BindParameters( HSTMT hstmt )`
`void`	`Cancel()`
`BOOL`	`CanTransact() const`
`BOOL`	`CanUpdate() const`
`virtual BOOL`	`Check( RETCODE nRetCode ) const`
`BOOL PASCAL`	`CheckHstmt( RETCODE, HSTMT hstmt ) const`
`virtual void`	`Close()`
`BOOL`	`CommitTrans()`
`protected BOOL`	`Connect( DWORD dwOptions )`
`void`	`ExecuteSQL( LPCTSTR lpszSQL )`
`protected void`	`Free()`
`DWORD`	`GetBookmarkPersistence() const`
`const CString&`	`GetConnect() const`
`protected void`	`GetConnectInfo()`
`int`	`GetCursorCommitBehavior() const`
`int`	`GetCursorRollbackBehavior() const`
`CString`	`GetDatabaseName() const`
`BOOL`	`IsOpen() const`
`virtual void`	`OnSetOptions( HSTMT hstmt )`
`virtual BOOL`	`Open( LPCTSTR lpszDSN, BOOL bExclusive = FALSE, BOOL bReadonly = FALSE, LPCTSTR lpszConnect = _T("ODBC" ), BOOL bUseCursorLib = TRUE )`
`virtual BOOL`	`OpenEx( LPCTSTR lpszConnectString, DWORD dwOptions = 0 )`
`void`	`ReplaceBrackets( LPTSTR lpchSQL )`
`BOOL`	`Rollback()`
`void`	`SetLoginTimeout( DWORD dwSeconds )`
`void`	`SetQueryTimeout( DWORD dwSeconds )`
`void`	`SetSynchronousMode( BOOL bSynchronous )`
`protected virtual void`	`ThrowDBException( RETCODE nRetCode )`
`protected void`	`VerifyConnect()`

Methods inherited from class CObject

GetRuntimeClass, new, new, delete, IsSerializable, IsKindOf, Serialize

Field Detail

m_bAddForUpdate

public BOOL m_bAddForUpdate;

m_bIncRecordCountOnAdd

public BOOL m_bIncRecordCountOnAdd;

m_bStripTrailingSpaces

public BOOL m_bStripTrailingSpaces;

m_bTransactions

protected BOOL m_bTransactions;

m_bUpdatable

protected BOOL m_bUpdatable;

m_chIDQuoteChar

public char m_chIDQuoteChar;

m_dwBookmarkAttributes

protected DWORD m_dwBookmarkAttributes;

m_dwLoginTimeout

protected DWORD m_dwLoginTimeout;

m_dwQueryTimeout

protected DWORD m_dwQueryTimeout;

m_dwUpdateOptions

protected DWORD m_dwUpdateOptions;

m_hdbc

public HDBC m_hdbc;

m_hstmt

protected HSTMT m_hstmt;

m_listRecordsets

protected CPtrList m_listRecordsets;

m_nCursorCommitBehavior

protected SWORD m_nCursorCommitBehavior;

m_nCursorRollbackBehavior

protected SWORD m_nCursorRollbackBehavior;

m_nTransactionCapable

protected SWORD m_nTransactionCapable;

m_reserved1

public char m_reserved1[ 3 ];

m_strConnect

protected CString m_strConnect;

nRefCount

protected int nRefCount;

Constructor Detail

CDatabase

public CDatabase();

~CDatabase

public virtual ~CDatabase();

Method Detail

AllocConnect

protected void AllocConnect( DWORD dwOptions );

BeginTrans

public BOOL BeginTrans();

BindParameters

public virtual void BindParameters( HSTMT hstmt );

Cancel

public void Cancel();

CanTransact

public BOOL CanTransact() const;

CanUpdate

public BOOL CanUpdate() const;

Check

public virtual BOOL Check( RETCODE nRetCode ) const;

CheckHstmt

public BOOL PASCAL CheckHstmt( RETCODE, HSTMT hstmt ) const;

Close

public virtual void Close();

CommitTrans

public BOOL CommitTrans();

Connect

protected BOOL Connect( DWORD dwOptions );

ExecuteSQL

public void ExecuteSQL( LPCTSTR lpszSQL );

Free

protected void Free();

GetBookmarkPersistence

public DWORD GetBookmarkPersistence() const;

GetConnect

public const CString& GetConnect() const;

GetConnectInfo

protected void GetConnectInfo();

GetCursorCommitBehavior

public int GetCursorCommitBehavior() const;

GetCursorRollbackBehavior

public int GetCursorRollbackBehavior() const;

GetDatabaseName

public CString GetDatabaseName() const;

IsOpen

public BOOL IsOpen() const;

OnSetOptions

public virtual void OnSetOptions( HSTMT hstmt );

Open

public virtual BOOL Open( LPCTSTR lpszDSN, BOOL bExclusive = FALSE, BOOL bReadonly = FALSE, LPCTSTR lpszConnect = _T("ODBC;" ), BOOL bUseCursorLib = TRUE );

OpenEx

public virtual BOOL OpenEx( LPCTSTR lpszConnectString, DWORD dwOptions = 0 );

ReplaceBrackets

public void ReplaceBrackets( LPTSTR lpchSQL );

Rollback

public BOOL Rollback();

SetLoginTimeout

public void SetLoginTimeout( DWORD dwSeconds );

SetQueryTimeout

public void SetQueryTimeout( DWORD dwSeconds );

SetSynchronousMode

public void SetSynchronousMode( BOOL bSynchronous );

ThrowDBException

protected virtual void ThrowDBException( RETCODE nRetCode );

VerifyConnect

protected void VerifyConnect();