Parameter Object

The Parameter object represents a parameter of stored procedure. An instance of this object can be retrieved by using the CreateParameter method or from the Parameters collection.

Properties

Name The name of the object for indentification in the collection.
Description The parameter description.
Type The parameter type.
Size The parameter size.
Scale The number of digits after the decimal point.
AsString Represents the contents of the parameter as a string.
AsLong Represents the contents of the parameter as an integer number.
AsDouble Represents the contents of the parameter as an real number.
AsBoolean Represents the contents of the parameter as a boolean value.

Methods

CreateProperty Creates a Property object, that describes a user-defined property.
Properties Provides access to the Parameters collection.

Remarks

Property objects can be built-in or user-defined.

To create a user-defined Property object for one of the objects, call the CreateProperty method of this object, and then add it to the Properties collection with the Append method. Only user-defined objects can be removed from teh Properties collection.

 

See Also

Properties Object, Append Method, CreateProperty Method