0 Replies Latest reply: Nov 21, 2013 4:58 AM by Parinita. RSS

    Changing number format mask at runtime to display currency based on certain criterias.

    Parinita.

      Hi,

       

      I need some help on the below topic.

       

      I have a price field (number) in Oracle forms.

      My form will be used in various countries, hence according to the site I will have to show the price in relevant country.

      I tried writing the code below, but it's throwing an error.

       

      Here is my code below.

       

      if :global.site in ('31','06') then

         set_item_property('prestations.prix',format_mask,'£999990.99');

      elsif :global.site in ('93') then

        set_item_property('prestations.prix',FORMAT_MASK,'999990.99"€"');

      elsif :global.site in ('94') then

        set_item_property('prestations.prix',FORMAT_MASK,'$999990.99');

      end if;

       

       

      Could any one advice, the correct way to achieve this?