| Re: HOW TO Retreive data to a tabular form (URGENT PLS HELP) [message #78408] |
Wed, 20 February 2002 21:24  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
