IsValid (Command Interface)

IsValid (Command Interface)

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