Share via


Update (Command Interface)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The Update method of the Command interface saves the definition of a command object in the metadata repository.

Applies To:clsDatabaseCommand

Syntax

object.Update

Parameters

  • object
    The command object to update.

Remarks

Use this method when you want to save changes to an object. Any changes made to an object will have session scope until this method is executed.

Example

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

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

See Also

Reference