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