RMONEY ( Format mask ) [message #302531] |
Tue, 26 February 2008 01:08  |
jhedshi
Messages: 13 Registered: February 2008
|
Junior Member |
|
|
there is a text item in the FORM and datatype is RMONEY
There is also a format mask FM9999999999990.00 on the text item.
Can the field have a negative value as in -100.00 . There are no other validations on the field.
aj
|
|
|
Re: RMONEY ( Format mask ) [message #302544 is a reply to message #302531] |
Tue, 26 February 2008 01:53  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Quote: | Can the field have a negative value as in -100.00 .
| Yes, it can.
Why didn't you try to insert -100 and see what happens?
Besides, RMONEY is here only for backward compatibility. It is recommended to use a NUMBER data type and apply a format mask which will produce a right-justified number.
|
|
|