| FRM - 40600 Record has already been inserted ... strange problem [message #236954] |
Fri, 11 May 2007 07:13  |
Catty
Messages: 64
Registered: April 2006
Location: Poland
|
Member |
|
|
Hello
I have very urgent problem and I still have no idea how to solve it.
I have two windows and two blocks of data: let's say window A with BLOCK A(sl_form) and window B with BLOCK B (formy).
In window A, in BLOCK A I create a new record (F6). After that window B with BLOCK B appears. I put some data into window B. Those data modify inserted record in window A in block A. When I want to save this data I get error FRM - 40600 that record has already been inserted?
Block A have triggers:
KEY-EXIT
go_block('kont');
hide_page(4);
and
KEY-CREREC
declare nr_f number;
begin
create_record;
select nvl(max(id_formy),0)+1 into nr_f
from kartoteka_form
where zaklad=:global.zaklad;
:global.id_formy :=nr_f;
:sl_form.id_formy:=nr_f;
:sl_form.zaklad :=:global.zaklad ;
:sl_form.id_masz :=:global.id_masz;
end;
go_block('formy');
hide_page(8);
execute_query;
Block B have triggers:
KEY-EXIT
:sl_form.id_formy :=:formy.id_formy ;
:sl_form.opis :=:formy.opis ;
:sl_form.nr_inwent:=:formy.nr_inwent;
:sl_form.data_zak :=:formy.data_zak ;
:sl_form.sprawna :=:formy.sprawna ;
:sl_form.il_gniazd:=:formy.il_gniazd;
:sl_form.zaklad :=:formy.zaklad ;
:sl_form.id_masz :=:formy.id_masz ;
:sl_form.id_wyr :=:formy.id_masz ;
go_block('sl_form');
execute_query;
hide_page(6);
Please help because I give up 
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
What should be done:
make sure primary key under the property palette is set to no.