IsValid (Command Interface)
[!NOTA]
Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.
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
Osservazioni
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.
Esempio
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