Partilhar via

  • Artigo

IsValid (Command Interface)

ObservaçãoObservação

  Esse recurso será removido na próxima versão do Microsoft SQL Server. Não utilize esse recurso em desenvolvimentos novos e modifique, assim que possível, os aplicativos que atualmente o utilizam.

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

Comentários

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.

Exemplo

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