>For some reason some num. fields in my table have numeric overflow,
>I don't know how to prevent the message 'Numeric overflow. Data was lost (Error 39)' when using this field
>
>Thanks in advance
>Zoran Milivojevic
>zoran@dunavel.com
If any field's new value is greater than it could hold you woul dget Numeric overflow. ie: Say you have a field defined as N 3.4 and a calculation tries to set it to 1000 would cause it. Integer field would hold up to 0xFFFFFFFF and 0x100000000 would cause overflow. If your field is type numeric than increase its size to a value that it could hold your maximum possible data. If it's integer, change to double, float or numeric.
Cetin