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

    Oracle form 10gR2

    Ade2

      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