다음을 통해 공유

  • 아티클

LockObject (Command Interface)

[!참고]

  이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.

The LockObject method of the Command interface locks an object to prevent multiple users from concurrently changing the object.

Applies To: clsDatabaseCommand

구문

object.LockObject(ByVal LockType As OlapLockTypes, ByVal LockDescription As String)

매개 변수

  • object
    The object to lock.

  • LockType
    One of the lock types of the OlapLockTypes enumeration. For more information, see OlapLockTypes.

  • LockDescription
    A string that contains a description of the lock. This argument is available to other applications attempting to obtain a lock.

주의

Of the four types of locks defined by the OlapLockTypes enumeration, only olapLockRead and olapLockWrite apply to the Command interface.

Lock type

Applies to

olapLockRead

Applications can read the properties of the command object from the repository but cannot make changes until the lock is released (this includes the application that created the lock).

olapLockWrite

The application that created the lock can modify the object's properties and save them in the repository using the Update method. Other applications cannot read the properties of the object until the lock is released.

For more information about object locking, see LockObject.

예

The following example locks a command object so that it can be modified. It then unlocks the object and updates the repository information for that object.

'Assume a command object (dsoCmd) exists.
dsoCmd.LockObect OlapLockRead, "Updating command, please wait."
' (Insert code to change command object here.)
dsoCmd.Update
dsoCmd.UnlockObject

참고 항목

참조

Command Interface