다음을 통해 공유


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

참고 항목

참조

Command Interface
Name (Command Interface)
Statement (Command Interface)

도움말 및 정보

SQL Server 2005 지원 받기