OraFAQ Forum: Forms » simultaneous access of the same record from two different machines

Home » Developer & Programmer » Forms » simultaneous access of the same record from two different machines

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

simultaneous access of the same record from two different machines [message #79601]

Tue, 25 June 2002 05:48

Ranjith Peddireddy
Messages: 7
Registered: June 2002

Junior Member

hi all,
i am having a table emp
(fields :: empno,ename,designation,.......)
in that i have 4records like
a1, a2,a3, a4.
i had created a form ,using the above table.
in tht the provision is if i enter the empno,
all the other fields should be retrieved.
i had a problem when i am accessing the same record (let it be a2) from the same form but from two different terminals .Imean to say
i had opened the form in the designer mode, and in the runform i will entry the a2 record's emp no and will
retrieve the data.

the same form i will open from other terminal ,
and will enter the a2 record's empno ,
then itz displaying the error as

Could not reserve record(2 tries)
keep trying

and prompts for YES or NO
if YES then it displays

Could not reserve record(4 tries)
keep trying

again prompts for YES or NO

if YES then it displays

Could not reserve record(6 tries)
keep trying

in the message , it goes on increasing the tries to
adding 2

help me,
Tx in advance.
ranjith.

Report message to a moderator

Re: simultaneous access of the same record from two different machines [message #79602 is a reply to message #79601]

Tue, 25 June 2002 06:36

N
Messages: 26
Registered: April 2002

Junior Member

hi,
this is a common problem for which there are many answers but not necessarily solutions! The database throws this type of error when there are two sessions tryin gto access the same record because these two sessions (people) might want to update the same record which is not feasible. Violates dbase constraints.

arios

Report message to a moderator

Re: simultaneous access of the same record from two different machines [message #79615 is a reply to message #79601]

Wed, 26 June 2002 23:04

Tyler
Messages: 123
Registered: January 2002

Senior Member

Try locking the record if it is currently begin updated and used... This will allow another user to realize that it is locked, instead of getting an ugly message.

Report message to a moderator

Previous Topic:	ORDER BY..... IN TLIST
Next Topic:	Exit_form trouble

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 11:53:06 CDT 2025