| Form 6i Displaying oracle Only negative sign [message #570561] |
Mon, 12 November 2012 05:20  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
