|
RANGE
Returns the range of the values displayed in the rows of the table controls. The function accepts values from textbox, label and literal controls which are a part of the specified table control. This function is called as <TableControlName>.RANGE("<ControlName>"). Use a TableControl instance to indicate which TableControl contains the values to be operated on by the function (e.g., Order_DetailsTableControl, ProductsTableControl, CategoriesTableControl).
Syntax
= <TableControlName>.RANGE(controlName)
Parameters
|
controlName |
It represents the name of the control which contains the values whose range is to be calculated. The controlName should be a string (e.g., “UnitPrice”, “Quantity”, “Discount”). The values in the control can be an integer (e.g., 37), a decimal value (e.g., 37.48), a string. |
Return Type
Decimal
Examples
|
Example |
Returns |
|
= ProductsTableControl.RANGE(“UnitsInStock”) |
The range of the values displayed in the rows of the “UnitsInStock” control. |
|
= Order_DetailsTableControl.RANGE("Quantity") |
The range of the values displayed in the rows of the “Quantity” control. |
|
= Order_DetailsTableControl.RANGE("Discount") |
The range of the values displayed in the rows of the “Discount” control. |