FRM-40654 Another user has changed this record...

[hpaille]

I have a form which includes 2 blocks linked by a relation master-details. I can key and insert data without any problem, but when I save the data and go back to a line (details) and modify a field I have the message FRM-40654, although I am the only one to work on this record. I haven't got any database trigger that could interact so after a few hours of research I am a bit lost ! Help !
Note that I haven't got any problems with the 1st block (master).

Oracle forms 6i, Oracle application 11.5.8 (?).

 

[lewisp]

Check what code you have in your pre and post insert or update triggers, or pre and post commit. Also check if you have an ON-INSERT or an ON-UPDATE trigger in your block.

Have you built the form through the wizard or by hand?

 

[hpaille]

I have only the triggers ON-UPDATE and ON-INSERT, that do the update and insert as I am using views. I didn't do the form, but I guess it was through the wizard. I also have a post-query trigger to populate non based data.

 

[lewisp]

The code in your on-insert and on-update triggers will be causing the problem. What you are doing with that code is to replace the standard forms default processing for inserts and updates. You will need to change the ON-LOCK trigger as well to control the way forms is attempting to lock the record(s) you are updating.

If you cannot circumvent the problem try changing the data source type of the block to 'FROM clause query' and replace your view name with a select statement to see if that helps. I assume you will have an ON-DELETE trigger already set up?