Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2012
Visual C++
MFC and ATL
MFC Desktop Applications
Classes
CRecordset Class
CRecordset::AddNew
CRecordset::CanAppend
CRecordset::CanBookmark
CRecordset::Cancel
CRecordset::CancelUpdate
CRecordset::CanRestart
CRecordset::CanScroll
CRecordset::CanTransact
CRecordset::CanUpdate
CRecordset::CheckRowsetError
CRecordset::Close
CRecordset::CRecordset
CRecordset::Delete
CRecordset::DoBulkFieldExchange
CRecordset::DoFieldExchange
CRecordset::Edit
CRecordset::FlushResultSet
CRecordset::GetBookmark
CRecordset::GetDefaultConnect
CRecordset::GetDefaultSQL
CRecordset::GetFieldValue
CRecordset::GetODBCFieldCount
CRecordset::GetODBCFieldInfo
CRecordset::GetRecordCount
CRecordset::GetRowsetSize
CRecordset::GetRowsFetched
CRecordset::GetRowStatus
CRecordset::GetStatus
CRecordset::GetSQL
CRecordset::GetTableName
CRecordset::IsBOF
CRecordset::IsDeleted
CRecordset::IsEOF
CRecordset::IsFieldDirty
CRecordset::IsFieldNull
CRecordset::IsFieldNullable
CRecordset::IsOpen
CRecordset::m_hstmt
CRecordset::m_nFields
CRecordset::m_nParams
CRecordset::m_pDatabase
CRecordset::m_strFilter
CRecordset::m_strSort
CRecordset::Move
CRecordset::MoveFirst
CRecordset::MoveLast
CRecordset::MoveNext
CRecordset::MovePrev
CRecordset::OnSetOptions
CRecordset::OnSetUpdateOptions
CRecordset::Open
CRecordset::RefreshRowset
CRecordset::Requery
CRecordset::SetAbsolutePosition
CRecordset::SetBookmark
CRecordset::SetFieldDirty
CRecordset::SetFieldNull
CRecordset::SetLockingMode
CRecordset::SetParamNull
CRecordset::SetRowsetCursorPosition
CRecordset::SetRowsetSize
CRecordset::Update
Expand Minimize
This topic has not yet been rated - Rate this topic

CRecordset::SetLockingMode

Visual Studio 2012

Sets the locking mode to "optimistic" locking (the default) or "pessimistic" locking. Determines how records are locked for updates.

Copy 
void SetLockingMode( 
   UINT nMode  
);
nMode

Contains one of the following values from the enum LockMode:

  • optimistic   Optimistic locking locks the record being updated only during the call to Update.

  • pessimistic   Pessimistic locking locks the record as soon as Edit is called and keeps it locked until the Update call completes or you move to a new record.

Call this member function if you need to specify which of two record-locking strategies the recordset is using for updates. By default, the locking mode of a recordset is optimistic. You can change that to a more cautious pessimistic locking strategy. Call SetLockingMode after you construct and open the recordset object but before you call Edit.

Header: afxdb.h

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.