Home » Developer & Programmer » Forms » Form 6i Displaying oracle Only negative sign
Form 6i Displaying oracle Only negative sign [message #570561] Mon, 12 November 2012 05:20 Go to next message
agrawalamit
Messages: 1
Registered: August 2008
Location: NAOMUNDI
Junior Member
Hi
can you to display a field with negative value
S -- format mask display both sing + and -
MI -- format mask display negative sign at end
PR --Returns negative value in <angle brackets>. and Returns positive value with a leading and trailing blank.

I want the output should display only leading negative if the value is negative.
I have used S99990.99 as format Mask

but need output should display only leading negative if the value is negative.

Any suggestion is welcomed.
Re: Form 6i Displaying oracle Only negative sign [message #570562 is a reply to message #570561] Mon, 12 November 2012 05:59 Go to previous message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, you don't have to do anything. If you specify format mask as "99990.99", it will do exactly what you want: if a number is positive, you won't see anything but number itself. If it is negative, Forms will add "-" sign in front of it.
Previous Topic: Pop-up or alert on desktop
Next Topic: Save Record
Goto Forum:
  


Current Time: Wed Oct 01 06:01:10 CDT 2014

Total time taken to generate the page: 0.08450 seconds