Re: Forms: Format Mask

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/07/13
Message-ID: <smrmfofand6158_at_corp.supernews.com>#1/1

"NMU User" <USER_at_NMU.EDU> wrote in message news:8kl3qt$1spe$1_at_walter.acs.nmu.edu...
> Hi all,
> I am using oracle forms and I have a general question. When putting a
> format mask on and item, does the mask also get stored in the database. I
> am dealing with social security numbers and when someone types in 123456789
> I would like them to see 123-45-6789 but the database to store jsut
> 123456789.
>
> Thanks

The mask will make it to the database.
You'll have to create your field that the user sees as a non-database field and transfer the value without the '-' to a non-displayed database field, such as on POST-TEXT-ITEM and/or WHEN-VALIDATE-ITEM

if (x_ssn is not null and ssn is null) or
   (x_ssn is null and ssn is not null) or
   (x_ssn is not null and ssn is not null and x_ssn != ssn) then

   ssn := substr(x_ssn,1,3)||substr(x_ssn,5,2)||substr(x_ssn,8); end if;

-Matt
-Matt Received on Thu Jul 13 2000 - 00:00:00 CEST