Decimals in text value

EC
EC Member Posts: 56
edited 2006-07-07 in NAV/Navision Classic Client
Hi All.

Help needed.

I'm importing some text values through a dataport. But when it's imported two decimals are added to the value. Eg. text value 10000 (the last to digits are decimals), that is the correct value should be 100,00 but Navision insert the value as 10000 and then ads the ,00 (the value now being 10000,00, instead of the correct 100,00).

Anyone know how to solve this issue?

/EC

Answers

  • kriki
    kriki Member, Moderator Posts: 9,127
    In the "OnAfterImportRecord"-trigger, divide the value by 100. 
    "The Decimal" := "The Decimal" / 100;
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • EC
    EC Member Posts: 56
    Yeah, my solution too. I just thought there were som built-in mechanism for handling this.

    Thanks anyway.

    /EC

Categories