Hi,
I have a NUMBER field (I_VOLUME) in a table and I have a format of 99,999.999 on that field (I_VOLUME)in Oracle Forms. When the form displays, a query populates all fields, including I_VOLUME.
The problem is that the value from the table, for I_VOLUME, is 0.00353144. But the value is rounded to 0.004 in I_VOLUME in the form. I want the form to display 0.003, not a rounded value...
I could use TRUNC (I_VOLUME,3), that would give me what I want. BUT how do I incorporate the TRUNC function when the forms does the query? Or can I set something in the Property Palette for I_VOLUME in Oracle forms?
Please advise!
Thanks in advance,
Marc L