TDBParam Class
Represents a single named, typed SQL parameter and its value(s).
Remarks
For normal single-row execution the parameter carries one value, accessible through ParamValue. For batch (array DML) execution the parameter carries one value per row, accessible through ParamValues[Index]; use ArraySize to set the number of rows before filling the values.
Syntax
Unit: Aurelius.Drivers.Interfaces
TDBParam = class(TObject);Constructors
| Name | Description |
|---|---|
| Create | Overloaded Create(string, TFieldType) Create(string, TFieldType, Variant) Create(string, TFieldType, TDBParamValues) |
Methods
| Name | Description |
|---|---|
| Clone | Returns a deep copy of this parameter, including its name, type, and all values. |
| ToString | Returns a string representation of this parameter showing its name, value, and type. |
Properties
| Name | Description |
|---|---|
| ArraySize | Gets or sets the number of values in the parameter array, used for batch execution. |
| ParamName | Gets or sets the parameter name as referenced in the SQL statement. |
| ParamType | Gets or sets the field type that determines how the value is bound to the statement. |
| ParamValue | Gets or sets the single value for normal (non-batch) execution. Equivalent to ParamValues[0]. |
| ParamValues[Index] | Gets or sets the value at the specified index for batch (array DML) execution. |