다음을 통해 공유

  • 아티클

IsValid (Command Interface)

[!참고]

  이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.

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

주의

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.

예

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