Home » Developer & Programmer » Forms » Format Mask to Char Field (Forms 6i)
Format Mask to Char Field [message #461179] Wed, 16 June 2010 23:19 Go to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

Hi......

I want to add format mask on my field...

my field datatype is char in forms

and in database VARCHAR2(30)

and I want to add format mask as follows

12345-1234567-1

in format mask of this field property I give it to format mast like as

FMAAAAA"-"AAAAAAA"-"A

when I run the form and when I write and exit from this field then it returns the error.

FRM-40209: Field must be of form FMAAAAA"-"AAAAAAA"-"A

EDIT by VK: Seems your CAPS lock is on or the Shift is stuck.

[Updated on: Thu, 17 June 2010 00:25] by Moderator

Report message to a moderator

Re: Format Mask to Char Field [message #461184 is a reply to message #461179] Thu, 17 June 2010 00:26 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
when I write and exit from this field
What did you write?

By
Vamsi
Re: Format Mask to Char Field [message #461222 is a reply to message #461184] Thu, 17 June 2010 02:40 Go to previous messageGo to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

THANKS FOR YOUR REPLY...

I M NOT WRITING ANY THING....

I M SET FIELD PROPERTY FORMAT MAST AS FOLLOWS

FMAAAAA"-"AAAAAAA"-"A
Re: Format Mask to Char Field [message #461376 is a reply to message #461222] Thu, 17 June 2010 10:40 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Seems still your CAPS lock is on or the Shift is stuck.Quote:
when I run the form and when I write and exit from this field then it returns the error.
What do you mean by that?

By
Vamsi
Re: Format Mask to Char Field [message #465023 is a reply to message #461376] Mon, 12 July 2010 04:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

From the Oracle Forms documentation:
Quote:
Format Mask
FM099"-"99"-"9999
Description
Displays the social security number as formatted, including hyphens, even if end user enters only nine digits. To create a Social Security column, create an 11-character column, set to fixed length, with a format mask of 099"-"99"-"9999. This mask will accommodate Social Security numbers that begin with zero, accepting 012-34-5678 or 012345678 (both stored as 012345678).
andQuote:
Format Mask Restrictions
- When setting the Maximum Length property for a text item, include space for any embedded characters inserted by the format mask you specify.
- Format masks can contain a maximum of 30 characters.
- Forms Developer supports only ORACLE format masks that are used for both input and output. Output-only format masks, such as WW, are not supported.

Have you tried your form with the field defined as numeric?

David
Re: Format Mask to Char Field [message #465063 is a reply to message #465023] Mon, 12 July 2010 07:36 Go to previous message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

Thanks djmartin...

now i m solved my problem....

thanks again..
Previous Topic: How to execute a stored procedure with out parameter.
Next Topic: Client OLE2 excel rowcount
Goto Forum:
  


Current Time: Thu Oct 23 07:49:20 CDT 2014

Total time taken to generate the page: 0.17431 seconds