[comp.databases] ORACLE SQL*Forms Money Rounding

carl.pedersen@dartmouth.edu (Carl Pedersen) (07/27/90)

If a user enters an amount with more than 2 digits after the
decimal point into a field defined as a MONEY field in SQL*Forms
version 2.3.31, it gets *rounded* to the nearest cent.  I don't
want it to do that.  I want to reject entries like this.  Anybody
know a way to do this that's not too hard to implement?

It appears that the rounding gets done before the POST-CHANGE
trigger.  I can do the check with a POST-CHANGE trigger by
changing it to a NUMBER field, but then I lose the display
formatting that I want.