Public Member Functions | Static Public Attributes | List of all members
Proud::CAdoRecordset Class Reference
Inheritance diagram for Proud::CAdoRecordset:
Inheritance graph
[legend]

Public Member Functions

 CAdoRecordset (ADODB::_Recordset *rc)
 
CAdoRecordsetoperator= (ADODB::_Recordset *rc)
 
PROUD_API bool GetFieldValue (const TCHAR *pszFieldName, String &var)
 
PROUD_API bool GetFieldValue (const TCHAR *pszFieldName, UUID &var)
 
PROUD_API bool GetFieldValue (const TCHAR *pszFieldName, CPnTime &var)
 
PROUD_API CVariant GetFieldValue (const TCHAR *pszFieldName)
 
PROUD_API void SetFieldValue (const TCHAR *pszFieldName, const CVariant &value)
 
PROUD_API CVariant GetFieldValue (int index)
 
PROUD_API void SetFieldValue (int index, const CVariant &value)
 
 __declspec (property(get=GetFieldValue, put=SetFieldValue)) CVariant FieldValues[]
 
PROUD_API _bstr_t GetFieldNames (int index)
 
 __declspec (property(get=GetFieldNames)) _bstr_t FieldNames[]
 
PROUD_API void Close ()
 
PROUD_API void Close_NoThrow ()
 
bool IsEOF ()
 
PROUD_API bool IsOpened ()
 
PROUD_API void Update ()
 
PROUD_API void AddNew ()
 
PROUD_API void Delete ()
 
PROUD_API void Open (ADODB::_Connection *conn, DbOpenFor openFor, const TCHAR *lpszSQL)
 
PROUD_API void Open (ADODB::_Connection *conn, ADODB::CursorTypeEnum cursorType, ADODB::LockTypeEnum lockType, const TCHAR *lpszSQL)
 
PROUD_API void Open (void)
 
PROUD_API void OpenForUpdate ()
 
PROUD_API void CopyFrom (CAdoOfflineRecord &src)
 
PROUD_API void MoveNext ()
 
PROUD_API void MoveFirst ()
 
PROUD_API void MovePrevious ()
 
PROUD_API void MoveLast ()
 
PROUD_API bool MoveNextRecordset (long *recordsAffected=NULL)
 
PROUD_API void NextRecordset (OUT CAdoRecordset &outRecordset, OUT long *recordsAffected=NULL)
 

Static Public Attributes

static const int defaultCacheSize =100
 

Additional Inherited Members

Detailed Description

ADO Recordset class + some enhanced functions

Use

Member Function Documentation

Proud::CAdoRecordset::__declspec ( property(get=GetFieldValue, put=SetFieldValue)  )

Reads and writes field value.

  • It can read and write just about any type of data since it use CVariant as parameter.
  • It can use field string or 0 based index number as array factor.
Proud::CAdoRecordset::__declspec ( property(get=GetFieldNames)  )

This method obtain name of field.

  • It can use 0 based index number as an array factor.
PROUD_API void Proud::CAdoRecordset::AddNew ( )

TODO:translate needed.

PROUD_API void Proud::CAdoRecordset::Close ( )

ADODB will be closed.

PROUD_API void Proud::CAdoRecordset::Close_NoThrow ( )

ADODB will be closed.

  • throw will not occur.
PROUD_API void Proud::CAdoRecordset::CopyFrom ( CAdoOfflineRecord src)

TODO:translate needed.

PROUD_API void Proud::CAdoRecordset::Delete ( )

TODO:translate needed.

bool Proud::CAdoRecordset::IsEOF ( )
inline

TODO:translate needed.

PROUD_API bool Proud::CAdoRecordset::IsOpened ( )

TODO:translate needed.

PROUD_API void Proud::CAdoRecordset::MoveFirst ( )

This method moves cursor to the initial record

PROUD_API void Proud::CAdoRecordset::MoveLast ( )

This method moves cursor to the last record.

PROUD_API void Proud::CAdoRecordset::MoveNext ( )

This method moves cursor to the next record.

PROUD_API bool Proud::CAdoRecordset::MoveNextRecordset ( long *  recordsAffected = NULL)

This method moves to the next recordset.

  • Assign the next recordset to itself.
    Parameters
    recordsAffectedNumber of records being affected by query
PROUD_API void Proud::CAdoRecordset::MovePrevious ( )

This method moves cursor to the previous record

PROUD_API void Proud::CAdoRecordset::NextRecordset ( OUT CAdoRecordset outRecordset,
OUT long *  recordsAffected = NULL 
)

This method passes the next recordset to a different instance.

Parameters
outRecordsetRecordset instance which will receive the next recordset
recordsAffectedNumber of records being affected by query
PROUD_API void Proud::CAdoRecordset::Open ( ADODB::_Connection *  conn,
DbOpenFor  openFor,
const TCHAR *  lpszSQL 
)

This method opens Recordset.

Parameters
connDB Link Object
openForOpenForRead: Read Only, OpenForReadWrite, OpenForAppend: Read/Write. The most optimized values for game server use.
lpszSQLQuery Syntax.
PROUD_API void Proud::CAdoRecordset::Open ( ADODB::_Connection *  conn,
ADODB::CursorTypeEnum  cursorType,
ADODB::LockTypeEnum  lockType,
const TCHAR *  lpszSQL 
)

This method opens Recordset.

Parameters
connDB Link Object
lpszSQLQuery Syntax.
PROUD_API void Proud::CAdoRecordset::Open ( void  )

This method opens all parameters as default value. This can be used when opening recordset object returned by ADO command.

PROUD_API void Proud::CAdoRecordset::OpenForUpdate ( )

This method opens all parameters as default value. This can be used when opening recordset object returned by ADO command.

PROUD_API void Proud::CAdoRecordset::Update ( )

TODO:translate needed.