List of OLE-DB parameter properties
- Last UpdatedSep 06, 2023
- 1 minute read
An OLE-DB parameter has the following properties. You can edit the parameter properties in the Parameter Collection Editor.
|
Property |
Description |
Valid values |
|---|---|---|
|
Direction |
Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored-procedure return-value parameter. |
Input, Output, InputOutput, ReturnValue. |
|
OleDbType |
Gets or sets the OLE DB data type. |
Empty, Smallnt, Integer, Single, Double, Currency, Date, BSTR, IDispatch, Error, Boolean, Variant, IUnknown, Decimal, TinyInt, UnsignedTinyInt, UnsignedSmallnt, UnsignedInt, BigInt, UnsignedBigInt, Filetime, Guid, Binary, Char, WChar, Numeric, DBDate, DBTime, DBTimeStamp, PropVariant, VarNumeric, VarChar, LongVarChar, VarWChar, LongVarWChar, VarBinary, LongVarBinary. |
|
Precision |
Gets or sets the maximum number of digits used to represent the Value property. Used for decimal and numeric input parameters. |
|
|
Scale |
Gets or sets the number of decimal places to which the Value property is resolved. |
|
|
Size |
Gets or sets the maximum size, in bytes, of the data in the column. |
|
|
SourceColumn |
Gets or sets the name of the source column mapped to the dataset and used to load or return the Value. |
|
|
SourceVersion |
Gets or sets the DataRowVersion to use when Value is loaded. Used by UpdateCommand during an Update operation to determine whether the parameter value is set to Current or Original. |
Original, Current, Proposed, Default. |
|
Value |
Gets or sets the value of the parameter. |
|
|
ParameterName |
Gets or sets the name of the parameter. |