FORMAT OF DATA IN FORMS 6i [message #678440] |
Wed, 04 December 2019 05:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/dd7dfae0b2dae95edebd2238eadcebb6?s=64&d=mm&r=g) |
Boumati
Messages: 21 Registered: November 2019
|
Junior Member |
|
|
Hi,
thank you for telling me, the displaying format, to force the sign (+ or -) of the input data in the oracle/form 6i
thanks a lot by advance.
|
|
|
Re: FORMAT OF DATA IN FORMS 6i [message #678480 is a reply to message #678440] |
Sun, 08 December 2019 13:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Can't test on Forms right now, but you can check whether the S format mask helps, such as in this example:
SQL> select to_char(1234, 'S999g990d00') positive,
2 to_char(-123, 'S999g990d00') negative
3 from dual;
POSITIVE NEGATIVE
----------- -----------
+1.234,00 -123,00
SQL>
Therefore, you'd put something like S999g990d00 into item's Property Palette.
|
|
|