1.5 Parameter Object

A parameter or argument associated with a Command object based on a query or stored procedure.

1.5.1 Name property

Sets or returns the name of a Parameter object.

Syntax

object.Name[=Object As String]

Type

String.

Attributes

Read/write.

Remarks

Object is an optional parameter that sets the name of the Parameter object.

1.5.2 Size property

Indicates the object’s maximum size, in bytes or characters.

Syntax

object.Size

Type

Integer.

Attributes

Read-only.

Remarks

String is an optional parameter that sets the name of the Parameter object.

1.5.3 Type property

Indicates the type of the Parameter value.

Syntax

object.Type

Type

Long.

Attributes

Read/write.

Remarks

Valid types include:

adBoolean

A Boolean value.

adChar

A String value.

adDate

A Date value.

adDouble

A double-precision floating point value.

adInteger

A 4-byte integer.

adNumeric

An exact numeric value with a fixed precision and scale.

adVarChar

A String value.

1.5.4 Value property

Contains the value of the Parameter object.

Syntax

object.Value[=Object As Variant]

Type

Variant. Default value depends on the Type property.

Attributes

Read/write.

Remarks

Object is an optional parameter that sets the value of the object.