Path: utzoo!attcan!uunet!jarthur!usc!zaphod.mps.ohio-state.edu!rpi!bu.edu!dartvax!eleazar.dartmouth.edu!carl
From: carl.pedersen@dartmouth.edu (Carl Pedersen)
Newsgroups: comp.databases
Subject: ORACLE SQL*Forms Money Rounding
Keywords: ORACLE, SQL*Forms, MONEY, Rounding
Message-ID: <23373@dartvax.Dartmouth.EDU>
Date: 26 Jul 90 18:59:07 GMT
Sender: news@dartvax.Dartmouth.EDU
Organization: Dartmouth College, Hanover, NH
Lines: 10
Originator: carl@eleazar.dartmouth.edu

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.