IsValid (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 IsValid property of the Command interface indicates whether the Name and Statement properties are empty and whether the command object belongs to a collection.
Applies To:clsCubeCommand, clsDatabaseCommand, clsRoleCommand
Data Type
Boolean
Access
Read-only
Remarks
Because of the flexible nature of command objects, only the following checks are performed:
- The Name property of the command object is not empty.
- The Command object belongs to a Commands collection.
- The Statement property of the command object is not empty.
Executing a command is the only way to determine whether the command functions correctly.
Example
Use the following code to return the validity status of a command object:
'Assume a command object (dsoCmd) exists.
If dsoCmd.IsValid Then
'Insert code to save the command.
Else
'Return an error with one or more properties.
End If
See Also
Reference
Command Interface
Name (Command Interface)
Statement (Command Interface)