Home » Developer & Programmer » Forms » FRM-40654 after using set record property on a database block (R12.2.9 EBS)
FRM-40654 after using set record property on a database block [message #690407] Thu, 21 August 2025 18:31 Go to next message
salviabu
Messages: 1
Registered: August 2025
Junior Member
Hello,

This is a very old design.

We have a custom form have 3 blocks.

Block A, Block B, Block C.

This form is opened from another custom form by passing parameters.

Those parameters are used in where clause for Block B and Block C.

In the Post-Query of Blocks B and C, the fields for Block A are populated.

Definitely, even if no changes are made to Block A, and if we close the form, it says

"Do you want to save"

Now the client does not want this message.

We tried adding below in the Post-Query of Block B( since that one fires after post-query of Block A)

set_Record_property(:system.TRIGGER_RECORD, 'Block A', status, query_Status);


But, now we get FRM-40654 Record has been updated by another user. Re-query to see change.

What would be the best approach to handle this?
Re: FRM-40654 after using set record property on a database block [message #690410 is a reply to message #690407] Wed, 27 August 2025 03:49 Go to previous message
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't make changes to block A from the post-query on B and C.

That's the root of your problem, so why are you doing it?
Previous Topic: Forms12c application crashing with Record Group
Next Topic: Free software replacement for Oracle Forms
Goto Forum:
  


Current Time: Mon Sep 08 02:37:06 CDT 2025