OraFAQ Forum: Forms » how to increment

Home » Developer & Programmer » Forms » how to increment

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to increment [message #320739]

Fri, 16 May 2008 02:56

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..

Report message to a moderator

Re: how to increment [message #320741 is a reply to message #320739]

Fri, 16 May 2008 03:04

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi

Maintain lastnumber in anytable. like 'Lastdocs'

or else

creat sequence.

wbr
kanish

Report message to a moderator

Re: how to increment [message #320744 is a reply to message #320741]

Fri, 16 May 2008 03:15

yjOy
Messages: 8
Registered: May 2008

Junior Member

how will i maintain last number in any tabLe?

thanks

Report message to a moderator

Re: how to increment [message #320757 is a reply to message #320739]

Fri, 16 May 2008 03:28

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: how to increment [message #320773 is a reply to message #320757]

Fri, 16 May 2008 03:55

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 461 times)

Report message to a moderator

Re: how to increment [message #320779 is a reply to message #320773]

Fri, 16 May 2008 04:17

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: how to increment [message #320788 is a reply to message #320739]

Fri, 16 May 2008 04:39

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: how to increment [message #320972 is a reply to message #320788]

Sat, 17 May 2008 02:43

yjOy
Messages: 8
Registered: May 2008

Junior Member

okay..i wiLL tRy..thanks for the heLp.. Smile

Report message to a moderator

Re: how to increment [message #320981 is a reply to message #320972]

Sat, 17 May 2008 05:07

Littlefoot
Messages: 21823
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:06:43 CST 2025