Hi all,
I have 2 canvas (1 canvas having database block items ,2nd having control block items & FIND button also in Control block), My requirement is when i select any one of the lov and click on the find button(in 2nd canvas , control block canvas) then it navigates to the database block canvas and displays records, at that time i want to display record count message. for this i add on-count trigger on form level, but not working, Could any one suggest me please.
- declare
- cnt number := 1;
- begin
- go_block('Blockname');
- first_record;
- while :system.last_record = 'FALSE'
- loop
- cnt := cnt + 1;
- next_record;
- end loop;
- message('There are ' || cnt || ' records in this block');
- end;
Thank You