MFC
Class CDaoQueryDef
CObject
|
+--CDaoQueryDef
in AFXDAO.H
- class CDaoQueryDef
- extends CObject
CDaoQueryDef - a DAO QueryDef
|
Method Summary |
virtual void |
Append()
|
BOOL |
CanUpdate()
|
virtual void |
Close()
|
virtual void |
Create( LPCTSTR lpszName = NULL, LPCTSTR lpszSQL = NULL )
|
virtual void |
Execute( int nOptions = dbFailOnError )
|
protected void |
FillParameterInfo( DAOParameter* pDAOParameter, CDaoParameterInfo& paraminfo, DWORD dwInfoOptions )
|
CString |
GetConnect()
|
COleDateTime |
GetDateCreated()
|
COleDateTime |
GetDateLastUpdated()
|
short |
GetFieldCount()
|
void |
GetFieldInfo( LPCTSTR lpszName, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 )
|
void |
GetFieldInfo( int nIndex, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 )
|
CString |
GetName()
|
short |
GetODBCTimeout()
|
short |
GetParameterCount()
|
void |
GetParameterInfo( LPCTSTR lpszName, CDaoParameterInfo& paraminfo, DWORD dwInfoOptions = 0x00000001 )
|
void |
GetParameterInfo( int nIndex, CDaoParameterInfo& paraminfo, DWORD dwInfoOptions = 0x00000001 )
|
virtual COleVariant |
GetParamValue( LPCTSTR lpszName )
|
virtual COleVariant |
GetParamValue( int nIndex )
|
long |
GetRecordsAffected()
|
BOOL |
GetReturnsRecords()
|
CString |
GetSQL()
|
short |
GetType()
|
protected void |
InitFieldsCollection()
|
protected void |
InitParametersCollection()
|
BOOL |
IsOpen() const
|
virtual void |
Open( LPCTSTR lpszName = NULL )
|
void |
SetConnect( LPCTSTR lpszConnect )
|
void |
SetName( LPCTSTR lpszName )
|
void |
SetODBCTimeout( short nODBCTimeout )
|
virtual void |
SetParamValue( LPCTSTR lpszName, const COleVariant& varValue )
|
virtual void |
SetParamValue( int nIndex, const COleVariant& varValue )
|
void |
SetParamValueNull( LPCTSTR lpszName )
|
void |
SetParamValueNull( int nIndex )
|
void |
SetReturnsRecords( BOOL bReturnsRecords )
|
void |
SetSQL( LPCTSTR lpszSQL )
|
protected virtual void |
ThrowDaoException( int nError = 0 )
|
m_bNew
protected BOOL m_bNew;
m_bOpen
protected BOOL m_bOpen;
m_pDAOFields
public DAOFields* m_pDAOFields;
m_pDAOParameters
public DAOParameters* m_pDAOParameters;
m_pDAOQueryDef
public DAOQueryDef* m_pDAOQueryDef;
m_pDatabase
public CDaoDatabase* m_pDatabase;
CDaoQueryDef
public CDaoQueryDef( CDaoDatabase* pDatabase );
~CDaoQueryDef
public ~CDaoQueryDef();
Append
public virtual void Append();
CanUpdate
public BOOL CanUpdate();
Close
public virtual void Close();
Create
public virtual void Create( LPCTSTR lpszName = NULL, LPCTSTR lpszSQL = NULL );
Execute
public virtual void Execute( int nOptions = dbFailOnError );
FillParameterInfo
protected void FillParameterInfo( DAOParameter* pDAOParameter, CDaoParameterInfo& paraminfo, DWORD dwInfoOptions );
GetConnect
public CString GetConnect();
GetDateCreated
public COleDateTime GetDateCreated();
GetDateLastUpdated
public COleDateTime GetDateLastUpdated();
GetFieldCount
public short GetFieldCount();
GetFieldInfo
public void GetFieldInfo( LPCTSTR lpszName, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 );
GetFieldInfo
public void GetFieldInfo( int nIndex, CDaoFieldInfo& fieldinfo, DWORD dwInfoOptions = 0x00000001 );
GetName
public CString GetName();
GetODBCTimeout
public short GetODBCTimeout();
GetParameterCount
public short GetParameterCount();
GetParameterInfo
public void GetParameterInfo( LPCTSTR lpszName, CDaoParameterInfo& paraminfo, DWORD dwInfoOptions = 0x00000001 );
GetParameterInfo
public void GetParameterInfo( int nIndex, CDaoParameterInfo& paraminfo, DWORD dwInfoOptions = 0x00000001 );
GetParamValue
public virtual COleVariant GetParamValue( LPCTSTR lpszName );
GetParamValue
public virtual COleVariant GetParamValue( int nIndex );
GetRecordsAffected
public long GetRecordsAffected();
GetReturnsRecords
public BOOL GetReturnsRecords();
GetSQL
public CString GetSQL();
GetType
public short GetType();
InitFieldsCollection
protected void InitFieldsCollection();
InitParametersCollection
protected void InitParametersCollection();
IsOpen
public BOOL IsOpen() const;
Open
public virtual void Open( LPCTSTR lpszName = NULL );
SetConnect
public void SetConnect( LPCTSTR lpszConnect );
SetName
public void SetName( LPCTSTR lpszName );
SetODBCTimeout
public void SetODBCTimeout( short nODBCTimeout );
SetParamValue
public virtual void SetParamValue( LPCTSTR lpszName, const COleVariant& varValue );
SetParamValue
public virtual void SetParamValue( int nIndex, const COleVariant& varValue );
SetParamValueNull
public void SetParamValueNull( LPCTSTR lpszName );
SetParamValueNull
public void SetParamValueNull( int nIndex );
SetReturnsRecords
public void SetReturnsRecords( BOOL bReturnsRecords );
SetSQL
public void SetSQL( LPCTSTR lpszSQL );
ThrowDaoException
protected virtual void ThrowDaoException( int nError = 0 );