FRM-40654: Record has been updated by another user
The case that I had was i changed the query of 1 database block dynamically use set_block_property(’BLOCK1′,Query_Data_Source_Name,’TABLE_X’). This BLOCK1 previously assign to TABLE_A. TABLE_X and TABLE_A has same fields structure.
FRM-40654
As summary, my form blocks condition were like this :
BLOCK1 = TABLE_A
Solution:
use set_block_property on pre_query trigger to change the query_data_source_name to TABLE_X.
Everything looks fine when i load the form, but when i tried to change the field value, it gave me this form error FRM-40654. I search around in Google and only can found several peoples face the same frm-40654 but in different situation.
set_block_property(’BLOCK1′,dml_data_target_name,’TABLE_X’)
