WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

ADO Parameter Object


Parameter Object

The ADO Parameter object gives data about a solitary parameter utilized in a put away method or query.  

A Parameter object is added to the Parameters Collection when it is made. The Parameters Collection is related with a particular Command object, which utilizes the Accumulation to pass parameters all through put away systems and queries.

Parameters can be utilized to make Parameterized Commands. These directions are (after they have been characterized and put away) utilizing parameters to adjust a few subtleties of the direction before it is executed. For instance, a SQL SELECT proclamation could utilize a parameter to characterize the criteria of a WHERE clause.

There are four kinds of parameters: input parameters, yield parameters, input/yield parameters and return parameters.

Syntax

objectname.property
objectname.method

Properties

Property Description
Attributes Sets or returns the properties of a Parameter object
Direction Sets or returns how a parameter is passed to or from a procedure
Name Sets or returns the name of a Parameter object
NumericScale Sets or returns the quantity of digits put away to one side side of the decimal point for a numeric estimation of a Parameter object
Precision Sets or returns the greatest number of digits permitted when speaking to numeric qualities in a Parameter
Size Sets or returns the most extreme size in bytes or characters of an incentive in a Parameter object
Type Sets or returns the kind of a Parameter object
Value Sets or returns the estimation of a Parameter object

Methods

Method Description
AppendChunk Appends long double or character information to a Parameter object
Delete Deletes an item from the Parameters Collection