Home » Developer & Programmer » Forms » FORMAT OF DATA IN FORMS 6i (ORACLE/FORMS 6i)
FORMAT OF DATA IN FORMS 6i [message #678440] Wed, 04 December 2019 05:27 Go to next message
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
Littlefoot
Messages: 21806
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.
Previous Topic: Forms 10g: builder crash while opening a Form even first connect (ctrl+j)
Next Topic: Delete_record in block.
Goto Forum:
  


Current Time: Thu Mar 28 13:15:39 CDT 2024