Greetings, Sanjoy -

1) What release and build of PB 2017 are you using?

2) What DBMS (vendor, version) does your app connect to?

3) What PB database driver and connection parameters (SQLCA.DBMS = ??? and SQLCA.DBParm = ???) Please show us the actual connection values being used (obscure any sensitive/security-related values, of course).

4) Can you export the DataWindow and post it here so that we can examine it? If not, can you reproduce the issue in a test DataWindow, then export that?

5) Does this issue occur when running the compiled application exe or from the PB IDE, or both? Is the application being built/deployed as 32-bit or 64-bit?

No other functions like round () is being used. I also have some other decimal fields in that screen with edit mask $#,###,##0.00. For those fields it is working fine. But for fields with edit mask ###.00 I am facing the problem.

Yes David, in column specification the type is Decimal 2 only.

Yes I have Decimal 2 as data type only.

In the "is it plugged  in" category:

Look at the data field itself, the one being displayed.
Check the number of decimal places and ensure that you a) HAVE decimal places in the field, and  b) that you have exactly 2 decimal places being displayed.


Olan

Hi Sanjoy;

  PB truncates on EditMasks & Display formats behaviour is to truncate. Check for other code like the Round() command that might be being used.

Regards ... Chris

Hi Sanjoy

Your edit mask is correct so something else is affecting the rounding, can you confirm that you column specifications are Decimal 2?

Cheers

David