Enumeration pvc.options.varia.DataTypeCheckingMode
Extends
string.
| Field Attributes | Field Name and Description |
|---|---|
|
Checks if columns declared as "String" are "Numeric",
based on the type and form of the first non-null value.
|
|
|
Checks if columns declared as "String" are "Numeric",
based on the type of first non-null value.
|
|
|
Trusts the data source column type metadata.
|
The column type metadata is sometimes incorrect due to the existence of nulls in the first row and the inability of some data sources to properly identify the data type in that case.
Other times, its incorrect just because... "Numeric" columns may be declared as "String", and contain either numbers or numeric strings.
The column type is established by the first row in which the column value is non-null. The type will be considered "Numeric" if the value is a JavaScript number or if it can be parsed as a number.
- Value:
- 'extended'
The column type is established by the first row in which the column value is non-null. The type will be considered "Numeric" if the value is a JavaScript number.
- Value:
- 'minimum'
- Value:
- 'none'