simultaneous access of the same record from two different machines [message #79601] |
Tue, 25 June 2002 05:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|