Format Mask to Char Field [message #461179] |
Wed, 16 June 2010 23:19 |
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 #465023 is a reply to message #461376] |
Mon, 12 July 2010 04:05 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS 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
|
|
|
|