A new option on the Advanced tab of the AcuODBC Configuration property sheet enables you to indicate how AcuODBC should treat non-numeric data in a numeric field. Values you can indicate are:
| To | Select |
| Treat non-numeric data in a numeric field as an assignment error | Error. This is the default. |
| Treat the first non-numeric character in a numeric field as the end of the numeric data (thus truncating the numeric data) | Truncate |
| Cause the field to be returned to the application as "0" if the field contains any non-numeric data | Zero |