The numeric type will now use the most adjusted sql server data type for storage. The data type used will depend on the Width and Decimal places you specify in the genio Numeric field:
| Genio Type | Width | Decimals | SqlType | Byte Size |
|---|---|---|---|---|
| Numeric | 1 - 4 | 0 | smallint | 2 |
| Numeric | 5 - 9 | 0 | int | 4 |
| Numeric | 10 - 15 | 0 | bigint | 8 |
| Numeric | 1 - 8 | 1 - N | real | 4 |
| Numeric | 9 - 15 | 1 - N | float | 8 |
| Decimal | 1 - 10 | 1 - N | decimal | 5 |
| Decimal | 11 - 15 | 1 - N | decimal | 9 |
Before you reindex the database you should make sure that the defined width and decimal places are compatible with any production data. Overflow errors will stop the reindex if any row data does not fit in the smaller data types.
Form conditions are now similar to table conditions, allowing to specify multiple conditions with a warning message associated