Insert Decimal value Above the range of Decimal Type

JedrzejT

Problem is about range of decimal fields

I try some operation on decimals and figure this out.

You can insert value of decimal only with range of Decimal to Decimal type Field/Variable , but next .. you can do some operation on this (like X 1000) to get the value above the range and unfortunatly save in table. Nav can take it :shock: but can't do next operation on this.

This Don't Work (Decimal must not be -100000000000000000. Decimal must be in the range of -999 999 999 999 999,99 - 999 999 999 999 999,99.")

Number:=1000000000000000

This Work

Number:=100000000000000; //(one 0 less)
Number:=Number*1000;
Tbl.DecField:=Number;
Tbl.INSERT;

After this we have in table value which can't be apply to other variable.
I have some problem with this, because "Adjust Cost - Item Entries" insert TOO big decimals to table (price error), and can't correct this on next start (error). Just share this :bug:

SQL Database Nav5 Sp1

kine

Native or SQL?