Format mask problem at Item Level . Intabular Form. [message #265717] |
Fri, 07 September 2007 02:43 |
musman
Messages: 147 Registered: July 2007 Location: Lahore
|
Senior Member |
|
|
DECLARE
v_len varchar2(25):=:uin;
v_len1 varchar2(25);
it_id Item;
BEGIN
it_id := Find_Item('uin');
v_len1:=length(v_len);
if v_len1 = 13 then
set_item_property(it_id,Format_Mask,'FM99999"-"9999999"-"9');
else
set_item_property(it_id,Format_Mask,'FM999"-"99"-"999999');
end if;
END;
--------------
this code is used on when_validate_item now problem is that when i give 13 digit code output is 12345-1234567-1 thats fine ..
and if code is 11 digit then output is 123-12-123456 but at same time field having 13 digit code converts to like ##########.How to handle two format masks on one item.
My form is tabular.
Using Forms 6i.
|
|
|
|
|
|
|