OraFAQ Forum: Forms » How to generate Serial Number?

Home » Developer & Programmer » Forms » How to generate Serial Number?

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

How to generate Serial Number? [message #520483]

Tue, 23 August 2011 01:32

0204ag
Messages: 11
Registered: August 2011
Location: Bahrain

Junior Member

hey,
how do you generate serial numbers? i have an invoice where i have to add items, so i want the numbering to start from 1 everytime i start a new form and increment by 1 as i i enter a new record. For this i have put my code in when-new-record-instance but problem is if i delete a record and enter a new one, the serial number starts from the nex number.
For ex. if i have 4 items with serial numbers 1, 2, 3, 4 and i delete the item at no. 3 and add a new item , the serial number comes as 5.
Can anyone suggest a proper code to generate the serial numbers?

Thanks.

Report message to a moderator

Re: How to generate Serial Number? [message #520678 is a reply to message #520483]

Wed, 24 August 2011 00:03

azamkhan
Messages: 557
Registered: August 2005

Senior Member

The solution is very simple my friend.

Generate your serial number at the time of saving.

Report message to a moderator

Re: How to generate Serial Number? [message #520679 is a reply to message #520678]

Wed, 24 August 2011 00:17

0204ag
Messages: 11
Registered: August 2011
Location: Bahrain

Junior Member

That i am doing but it doesn't come right.

Report message to a moderator

Re: How to generate Serial Number? [message #520703 is a reply to message #520679]

Wed, 24 August 2011 03:12

azamkhan
Messages: 557
Registered: August 2005

Senior Member

No my friend you are not doing what I am saying. You said , "I have put my code in when-new-record-instance but problem is if i delete a record and enter a new one, the serial number starts from the nex number."

The trigger WHEN-NEW-RECORD-INSTANCE fires when every you naviagtes to a new record. What I am suggesting is that try to execute your code at the time of commit event or when the commit event occur.

Report message to a moderator

Re: How to generate Serial Number? [message #520707 is a reply to message #520703]

Wed, 24 August 2011 03:18

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

And the trigger you would use for that is?

Report message to a moderator

Re: How to generate Serial Number? [message #520710 is a reply to message #520707]

Wed, 24 August 2011 03:33

azamkhan
Messages: 557
Registered: August 2005

Senior Member

My dear friend I had given you the fruit. You have to find a way to eat it by yourself...

Read the different events/trigger. I can tell you the trigger but you might forget it after some time but if you find it out by yourself, by putting the hard work you will remember it for ever.

I hope you understand for I am trying to say.

But... but..! if you would be able to find it out then in 3 days then ask me. I believe in

"Transfering knowledge to others let you also learn from others"

Report message to a moderator

Re: How to generate Serial Number? [message #520713 is a reply to message #520710]

Wed, 24 August 2011 03:54

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I know what all the triggers are, I'm not the OP.
Most of them don't allow unrestricted builtins - which you'll need if you want to populate multiple serial numbers.
The only one that does can be bypassed.

So again - which trigger did you have in mind?

Report message to a moderator

Re: How to generate Serial Number? [message #531045 is a reply to message #520713]

Sat, 12 November 2011 03:51

salman_atta
Messages: 2
Registered: November 2011
Location: pakistan

Junior Member

Please Use the pre_insert trigger

Report message to a moderator

Previous Topic:	send email through forms 6i
Next Topic:	Display code errors above Form 10g!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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