Friday 19 September 2014

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;

2 comments:

Copyright © ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com