This discussion is archived
1 Reply Latest reply: Oct 14, 2013 9:23 AM by Andreas Weiden RSS

Oracle form 10gR2

Ade2 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points