FRM-40102 (PLS HELP URGENT!!!!!!!!) [message #78419] |
Fri, 22 February 2002 04:38 |
Luigi
Messages: 11 Registered: February 2002
|
Junior Member |
|
|
hi experts,
When i push a button with trigger when_button_pressed and with code as below i get this kind of message:
FRM-40102: Record must be entered or deleted first.
, and some more the data keep on showing on the first line of a tabular form. It can not navigate to next line for new record; So what can i do to solve this problem
below is my code:
declare
cursor c1 is
select pel_no_matrik,pel_nama_pelajar,pel_no_kad_pengenalan,pel_tahun_masuk
from pelajar_peribadi;
--where pel_kod_biasiswa = :cr_biasiswa;
begin
create_record;
for i in c1 loop
:pelajar_peribadi.pel_no_matrik := i.pel_no_matrik;
:pelajar_peribadi.pel_nama_pelajar :=
i.pel_nama_pelajar;
:pelajar_peribadi.pel_no_kad_pengenalan := i.pel_no_kad_pengenalan;
:pelajar_peribadi.chk_pelajar := 0;
next_record;
end loop;
end;
pls help me.
|
|
|
Re: FRM-40102 (PLS HELP URGENT!!!!!!!!) [message #78428 is a reply to message #78419] |
Sun, 24 February 2002 08:52 |
Tamim
Messages: 23 Registered: October 2001
|
Junior Member |
|
|
There are only two things I can remember. One is this error will occur if the block is database true..
Also, try using the create_record within the cursor for loop. It might work then. Remove the next_record.
Regards
Tamim
|
|
|
Re: FRM-40102 (PLS HELP URGENT!!!!!!!!) [message #78447 is a reply to message #78419] |
Mon, 25 February 2002 04:30 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
try this
declare
cursor c1 is
select pel_no_matrik,pel_nama_pelajar,pel_no_kad_pengenalan,pel_tahun_masuk
from pelajar_peribadi;
--where pel_kod_biasiswa = :cr_biasiswa;
begin
for i in c1 loop
if :system.record_status!='NEW' then
create_record;
end if;
:pelajar_peribadi.pel_no_matrik := i.pel_no_matrik;
:pelajar_peribadi.pel_nama_pelajar :=
i.pel_nama_pelajar;
:pelajar_peribadi.pel_no_kad_pengenalan := i.pel_no_kad_pengenalan;
:pelajar_peribadi.chk_pelajar := 0;
end loop;
end;
|
|
|
|
Re: FRM-40102 (PLS HELP URGENT!) [message #182994 is a reply to message #86973] |
Wed, 19 July 2006 02:35 |
cong
Messages: 25 Registered: June 2006
|
Junior Member |
|
|
Hi! I encountered the same FRM error and I just did what you wrote. Instead of only create_record, I added the if statement:
if :system.record_status!='NEW' then
create_record;
end if;
It worked! Thanks so much!
|
|
|