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.