共用方式為


VariableDispenser.LockOneForWrite Method

Puts the variable in a list, and then locks it for read/write access.

命名空間: Microsoft.SqlServer.Dts.Runtime
組件: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

語法

'宣告
Public Sub LockOneForWrite ( _
    variable As String, _
    ByRef variables As Variables _
)
public void LockOneForWrite (
    string variable,
    ref Variables variables
)
public:
void LockOneForWrite (
    String^ variable, 
    Variables^% variables
)
public void LockOneForWrite (
    String variable, 
    /** @ref */ Variables variables
)
JScript 不支援以傳址方式傳遞值類型的引數。

參數

  • variable
    The name of the variable to lock for read/write access.
  • variables
    The name of the variables collection to put the requested variable into.

備註

This method combines the work of the LockForWrite method and the GetVariables method in one call, as it applies to a single variable only.

If the call succeeds, the requested variable is returned as a one-entry collection in the variable collection specified by the parameter variables, and the variable is locked for read/write access. To unlock the variable, release the variable collection using the Unlock method of the Variables class. If the LockOneForWrite method call fails, the variable is not locked.

Calls to this method do not affect the lock list generated by calls to LockForWrite.

ms191093.note(zh-tw,SQL.90).gif附註:
It is recommended that you do not make multiple calls to this method when acquiring locks for variables to be used together because this could lead to deadlocks. All variables being used together should be requested and locked together by calling the methods LockForRead or LockForWrite, followed by a call to the GetVariables.

If a lock was successful, you can clear it by calling Unlock.

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

目標平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

請參閱

參考

VariableDispenser Class
VariableDispenser Members
Microsoft.SqlServer.Dts.Runtime Namespace