Home » Developer & Programmer » Forms » Re: HOW TO Retreive data to a tabular form (URGENT PLS HELP)
Re: HOW TO Retreive data to a tabular form (URGENT PLS HELP) [message #78408] Wed, 20 February 2002 21:24 Go to next message
Manoj
Messages: 101
Registered: August 2000
Senior Member
Dear,

use cursor like that on Push button or what ever event u r using.

declare
cursor c1 is select msc_msc_code,msc_msc_desc
from fac_msc_p;
begin

create_record;
for i in c1 loop
:b1.t1:=i.msc_msc_code;
:b1.t2:=i.msc_msc_desc;
next_record;

end loop;
end;

where b1 is block name and t1,t2 are fields name
it will work properly.
FRM-40102 is shown ( HELP AGAIN) [message #78415 is a reply to message #78408] Thu, 21 February 2002 16:35 Go to previous messageGo to next message
Luigi
Messages: 11
Registered: February 2002
Junior Member
hi,
I hav try the matter u teach but is still hav problem.
when I push the button the data did show out, but the msg
FRM-40102: Record must be entered or deleted first.
is shown, and some more the data still keep on showing on the first line;

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 IS SHOWN(HELP AGAIN) [message #78416 is a reply to message #78408] Thu, 21 February 2002 16:38 Go to previous message
Luigi
Messages: 11
Registered: February 2002
Junior Member
hi,
I hav try the matter u teach but is still hav problem.
when I push the button the data did show out, but the msg
FRM-40102: Record must be entered or deleted first.
is shown, and some more the data still keep on showing on the first line;
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.
Previous Topic: Re: FREE TRAINING ON ORACLE AND DEVELOPER200 CONTACT BY MAIL STEP BY STEP TAINING
Next Topic: Refresh the tree
Goto Forum:
  


Current Time: Tue Mar 19 01:10:15 CDT 2024