Home » Developer & Programmer » Forms » how to increment
how to increment [message #320739] Fri, 16 May 2008 02:56 Go to next message
yjOy
Messages: 8
Registered: May 2008
Junior Member
hi! can anyone help me? please....

i am working on a form right now and i want the value of the receipt number to be incremented automatically by 1 whenever i want to insert another receipt.. how can this be done?

however, i find it hard to do it since
i don't have any idea and i just started
learning oracLe especially the form builder..

i would reaLLy appreciate your help..thnx! i need it badLy..
Re: how to increment [message #320741 is a reply to message #320739] Fri, 16 May 2008 03:04 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi

Maintain lastnumber in anytable. like 'Lastdocs'

or else

creat sequence.


wbr
kanish
Re: how to increment [message #320744 is a reply to message #320741] Fri, 16 May 2008 03:15 Go to previous messageGo to next message
yjOy
Messages: 8
Registered: May 2008
Junior Member
how will i maintain last number in any tabLe?

thanks
Re: how to increment [message #320757 is a reply to message #320739] Fri, 16 May 2008 03:28 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

A table which maintain the all types document lastnumber,lastdate which is prepared (table name like Lasdoc)

or

another way to get Max value the receipt and increment 1.

wbr

kanish

Re: how to increment [message #320773 is a reply to message #320757] Fri, 16 May 2008 03:55 Go to previous messageGo to next message
yjOy
Messages: 8
Registered: May 2008
Junior Member
here is a picture of my form,
i want that the user will no
longer input for the receipt number.
i want it to be automatically generated and incremented..

i don't know where to find the:
"A table which maintain the all types document lastnumber,lastdate which is prepared (table name like Lasdoc)"

im sorry if i aLways keep on asking..
i just don't know what to do..

thanks...
  • Attachment: hrc.JPG
    (Size: 47.27KB, Downloaded 90 times)
Re: how to increment [message #320779 is a reply to message #320773] Fri, 16 May 2008 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you had read the OraFAQ Forum Guide, you'd probably see "How to get a quick answer to your question" section. Among other options, it suggests you to search the board. As you know, your problem isn't unique and - believe or not - has been asked (and answered) many times.

Therefore, I'd suggest you to read previous threads about the same problem. You'll probably find the answer. If not, do return and explain what you did and why it doesn't work as you'd like it to.
Re: how to increment [message #320788 is a reply to message #320739] Fri, 16 May 2008 04:39 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

write in "When_button_pressed" on ADD.

  Begin 
   Select Max(Receiptno) into :Recptno
     from yrrecpttable;
  
  exception
   When no_data_found Then
      :Recptno := 1;
  End;
  



kanish
Re: how to increment [message #320972 is a reply to message #320788] Sat, 17 May 2008 02:43 Go to previous messageGo to next message
yjOy
Messages: 8
Registered: May 2008
Junior Member
okay..i wiLL tRy..thanks for the heLp.. Smile
Re: how to increment [message #320981 is a reply to message #320972] Sat, 17 May 2008 05:07 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm glad to see that your keyboard supports both lower and upper case. Now, please, learn how to properly use them. Upper case at the beginning of the sentence + personal names + etc. (and NOT in the middle of a word), lowercase elsewhere.

Because, the way you use them is annoying.
Previous Topic: Difference between Update-allowed and Update-only-if-null
Next Topic: How can store and download doc/pdf file in oracle
Goto Forum:
  


Current Time: Thu Dec 08 08:20:54 CST 2016

Total time taken to generate the page: 0.08966 seconds