1 Reply Latest reply: Oct 14, 2013 11:23 AM by Andreas Weiden RSS

    Oracle form 10gR2


      Hello Friends, I have a request to change database item seq number to left pad it  with 0's to 10 order On the formI put the code in when-new-item-instance

      :block.Itemname := lpad(:block.itemname,10,0)

      and in post query

      :block.Itemname := lpad(:block.itemname,10,0)

      copy ('block.itemname', 'block.itemname')

      but this does not change the display .

      Please advice. I only want the display to change not the base item