Home » Developer & Programmer » Forms » ...Error Updating/Inserting In Tables.
...Error Updating/Inserting In Tables. [message #161131] Thu, 02 March 2006 03:38 Go to next message
orcl_dba
Messages: 84
Registered: March 2005
Member
Hi all
I have table which contains the request data. requested by User.
There are 3 admins each at different region which can take action on the requests send by thier regional teams/users.

For Region A , it works fine that the Admin opens the Form,
View the requests and then pres Generate_report/or Cancel button , but before that he/she has to insert the comments/reason for his action.

Same thing when starts for Region B ,
suddenly i got a message
Unable to update or delete records.
Unable to reserve records for Update.

WHy is such message coming.

We have 2 Datablocks.
both from the s ame table .
One block shows the requestes. it is read only,

the other part shows only 1 field which is Comments, from the same table , both blocks joined by the request_id.

ANy body with suggestion plz.
same thing is working for Region A .
Admins are taking action on requests easiy
what happens ot Region B .

i have yet to implement it for Region C ,

but i have to resolve this for region B first
Kindly comment

Regards
Re: ...Error Updating/Inserting In Tables. [message #161136 is a reply to message #161131] Thu, 02 March 2006 03:50 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
this is probably because , the record in region B has,some how got locked. see a similar question at:

http://www.experts-exchange.com/Databases/Oracle/Q_21282962.html

for some suggestions
Re: ...Error Updating/Inserting In Tables. [message #161522 is a reply to message #161136] Sun, 05 March 2006 22:57 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Did this solve your problem?

David
Previous Topic: How to set the width of the 'current record' only.
Next Topic: hi
Goto Forum:
  


Current Time: Fri Sep 20 05:41:40 CDT 2024