FRM-40654 Record Updated by another user
AdeelSep 7 2011 — edited Sep 14 2011Hello Friends .. :)
I want to join to tables with connect prior query
I use this query and my result is ok ..
But when i try to use this query on form level
then I get this error ..
frm-40654: record updated by another user
Please tell me how to solve this problem..
Declare
msql long;
Begin
/*msql := ' (select * from time_attm a
where emp_ID = (select ID from personnel.personnel
where id = a.emp_id
connect by prior Id = mgr
start with id = ' || :global.id || '))';*/
set_block_property('time_attm', query_data_source_name,msql);
execute_query;
exception
When Others then
Message(Error_Code || ' : ' || Error_Text);
End;