OraFAQ Forum: Forms » how to generate unique document numbers when more than one user are inserting in a form at one time

Home » Developer & Programmer » Forms » how to generate unique document numbers when more than one user are inserting in a form at one time (forms 10G)

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

how to generate unique document numbers when more than one user are inserting in a form at one time [message #534267]

Mon, 05 December 2011 00:08

poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI

Member

Hello Sir,

I have made one application form where users need to enter some data. This data is getting inserted in four tables. As in for now the data is properly getting saved and retrieved only for one user at a time. But problem arrives when more than one users are simultaneously making an entry and saving the data at one time.Same number is getting generated for the users who are saving the data at one time which should not happen.
Can you please suggest any concept for this problem.

Thank you.

Report message to a moderator

Re: how to generate unique document numbers when more than one user are inserting in a form at one t [message #534278 is a reply to message #534267]

Mon, 05 December 2011 00:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use a sequence instead of whatever you use now.

Report message to a moderator

Re: how to generate unique document numbers when more than one user are inserting in a form at one t [message #534350 is a reply to message #534278]

Mon, 05 December 2011 08:27

aallan
Messages: 150
Registered: October 2011

Senior Member

you can change the db block property (Locking Mode = Delayed).

Report message to a moderator

Re: how to generate unique document numbers when more than one user are inserting in a form at one t [message #534353 is a reply to message #534350]

Mon, 05 December 2011 08:36

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

Senior Member

That may minimize the problem but it won't fix it. Sequence is the only guaranteed way.

Report message to a moderator

Re: how to generate unique document numbers when more than one user are inserting in a form at one t [message #534418 is a reply to message #534353]

Mon, 05 December 2011 21:45

poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI

Member

thank you so much ..the problem is solved by using sequence

Report message to a moderator

Previous Topic:	uploded/download files
Next Topic:	Pass Global Variable from form to db trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 05:58:17 CST 2025