1 Reply Latest reply on Oct 14, 2013 4:23 PM by Andreas Weiden

    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