I need to capture partial quantity information and store it in the tr_hist table in our MFG/PRO system.
For example:
tr__dec01 = 2 (number of complete widgets in a box)
tr__dec02 = .5555 (number of a partial widget in a box)
tr__dec03 = 2.5555 (total number of widgets in a box)
I know the default format in tr_hist for these fields is
[font=r_ansi]deci-10 >>>,>>>,>>9.99
I used my own format within the program
deci-10 >>>,>>>,>>9.99999, but when I try to print out these values in a report tr__dec02 comes out as 1.00 it rounds up.
Is there a way to correctly store a number like .5555 in the tr_hist table using the user reserved feilds ?
Thanks
[/font]
For example:
tr__dec01 = 2 (number of complete widgets in a box)
tr__dec02 = .5555 (number of a partial widget in a box)
tr__dec03 = 2.5555 (total number of widgets in a box)
I know the default format in tr_hist for these fields is
[font=r_ansi]deci-10 >>>,>>>,>>9.99
I used my own format within the program
deci-10 >>>,>>>,>>9.99999, but when I try to print out these values in a report tr__dec02 comes out as 1.00 it rounds up.
Is there a way to correctly store a number like .5555 in the tr_hist table using the user reserved feilds ?
Thanks
[/font]