You can fill the data dynamically in detail block in oracle forms just try this code hope it will helpfull for you
PROCEDURE fromcustomer IS
cursor c is
select code,name from customer where
sales_person2 = :SALESEXECUTIVE_BLOCK.from_se_code;
begin
go_block('fromcustomer_block');
clear_block(no_validate);
for rec in c loop
:fromcustomer_block.from_cust_code := rec.code;
:fromcustomer_block.from_cust_name := rec.name;
:fromcustomer_block.ck_from := 'Y';
NEXT_RECORD;
end loop;
first_record;
END;
PROCEDURE fromcustomer IS
cursor c is
select code,name from customer where
sales_person2 = :SALESEXECUTIVE_BLOCK.from_se_code;
begin
go_block('fromcustomer_block');
clear_block(no_validate);
for rec in c loop
:fromcustomer_block.from_cust_code := rec.code;
:fromcustomer_block.from_cust_name := rec.name;
:fromcustomer_block.ck_from := 'Y';
NEXT_RECORD;
end loop;
first_record;
END;
This is not workimg.. It is overwriting the first record itself.
ReplyDeletehttps://saglamproxy.com
ReplyDeletemetin2 proxy
proxy satın al
knight online proxy
mobil proxy satın al
PMFZM