Size Property

Indicates the maximum size, in bytes, of a Parameter object.

Settings and Return Values

Sets or returns a Long value that indicates the maximum size in bytes of a value in a Parameter object.

Remarks

Use the Size property to determine the maximum size for values written to or read from the Value property of a Parameter object. The Size property is read/write.

If you specify a variable-length data type for a Parameter object, you must set the object's Size property before appending it to the Parameters collection; otherwise an error occurs. If you have already appended the Parameter object to the Parameters collection of a Command object and you change its type to a variable-length data type, you must set the Parameter object's Size property before executing the Command object; otherwise an error occurs.