format mask [message #87845] |
Wed, 16 February 2005 09:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Nina
Messages: 113 Registered: March 2000
|
Senior Member |
|
|
I need to set the current format mask to non. How do I do that?
|
|
|
Re: format mask [message #87864 is a reply to message #87845] |
Fri, 18 February 2005 00:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
a
Messages: 22 Registered: March 2002
|
Junior Member |
|
|
if u want to dothis at run time use then
set_item_property('item_name',format_mask,9999);
else
just keep that propery blank ;
end if;
|
|
|
Re: format mask [message #87869 is a reply to message #87864] |
Fri, 18 February 2005 03:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Nina
Messages: 113 Registered: March 2000
|
Senior Member |
|
|
Thanks for the help, but what do you mean, "keep that property blank"? Blank as in, ' ' (empty quotes) or null or what?
|
|
|
|
Re: format mask [message #109025 is a reply to message #108964] |
Mon, 21 February 2005 04:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Nina
Messages: 113 Registered: March 2000
|
Senior Member |
|
|
I have a database phone number field on a form which holds a phone number (length 7-15 digits). I have to put a mask on this field, which depends on the number of digits the user enters in the phone field. I am using SET_ITEM_PROPERTY to do this. Now the user may or may not enter dashes, so input can be in the form 9999999999 or 999-999-9999.The number field will not allow the user to enter 999-999-9999 because it sees the dashes as a minus sign and I am getting an error, which I cannot handle in When-Validate-Item, because Validate item is firing before. How do I get around this?
|
|
|
|