Home » Developer & Programmer » Forms » Format masking of Numbers (Forms 6i Orable 9i)
Format masking of Numbers [message #326595] Thu, 12 June 2008 01:43 Go to next message
adchax
Messages: 32
Registered: June 2008
Member
hello!!
I have a requirement of format masking an item(number) to 999.999999,which is alright by itself,but when i put 0 it becomes .000000,how can i get just 0.
format masking to 000.000000 also doesnt help since then when i put 5 it will give 005.000000.

I need
5 5.000000
0 0.000000
12 12.000000
234 234.000000


Thanks
Re: Format masking of Numbers [message #326601 is a reply to message #326595] Thu, 12 June 2008 01:53 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Instead of 000"."000000 use 999"."000000
Re: Format masking of Numbers [message #326606 is a reply to message #326601] Thu, 12 June 2008 02:03 Go to previous messageGo to next message
adchax
Messages: 32
Registered: June 2008
Member
Thanks for the reply,but 999.000000 doesnt slove by 0 problem,when i type in 0 it comes as .000000 while i want 0.000000
Re: Format masking of Numbers [message #326607 is a reply to message #326606] Thu, 12 June 2008 02:04 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Then use 990.000000
Re: Format masking of Numbers [message #326623 is a reply to message #326607] Thu, 12 June 2008 02:18 Go to previous messageGo to next message
adchax
Messages: 32
Registered: June 2008
Member
I dont why its not working ...its giving ###.###### while displaying
Re: Format masking of Numbers [message #326642 is a reply to message #326623] Thu, 12 June 2008 02:41 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

then drag to expand the size of your item.
Re: Format masking of Numbers [message #326653 is a reply to message #326642] Thu, 12 June 2008 02:59 Go to previous messageGo to next message
adchax
Messages: 32
Registered: June 2008
Member
I fixed that but my intial problem is still not solved.How can I get 0 display instead of .000000
Re: Format masking of Numbers [message #326654 is a reply to message #326653] Thu, 12 June 2008 03:02 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Mr. adchax please do to an Eye Specialist and examine your eyes I think they are weak. I told you to use 990.00000 in format masking
Re: Format masking of Numbers [message #326668 is a reply to message #326654] Thu, 12 June 2008 03:55 Go to previous message
adchax
Messages: 32
Registered: June 2008
Member
Thank you that did work!
Maybe I do have to get my eyes checked!=)
Previous Topic: Function Keys in Forms 10G
Next Topic: running reports thru forms dynamically
Goto Forum:
  


Current Time: Mon Dec 05 08:57:23 CST 2016

Total time taken to generate the page: 0.04652 seconds