| Simple Loop does not populate the block correctly [message #399720] |
Thu, 23 April 2009 12:23  |
toku
Messages: 1
Registered: April 2009
|
Junior Member |
|
|
Hello,
this Statement in a procedure should populate a block of rows and coloumns.
for rec in
(select knf_kuerzel as system,
testfall_nr as tfnr,
test_dat as td,
ergebnis_kz as te,
test_wer as tw,
testfall_wer as tfw,
test_protokoll as tp
from sco_test_faelle
order by testfall_nr
)
loop
create_record;
-- record in block schreiben
:bl_testfaelle.tf_knf_kuerzel := rec.system;
:bl_testfaelle.tf_testfall_nr := rec.tfnr;
:bl_testfaelle.tf_testdatum := rec.td;
:bl_testfaelle.tf_ergebnis_kz := rec.te;
:bl_testfaelle.tf_test_wer := rec.tw;
:bl_testfaelle.tf_testfall_wer := rec.tfw;
:bl_testfaelle.tf_testprotokoll := rec.tp;
end loop;
The statement fetches all data correctly but Forms inserts the
selected rows all in the first row of the block.
Create_record does not work correctly.
Why?
It's the first time I'm programming with Forms 10.
In 1999 I coded the last Forms program on Forms 4.5, so
I'm not really a Forms - specialist 
Hoping someone can help, thanks for all
toku
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
