Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Record count message

994122Dec 19 2013 — edited Dec 20 2013

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.

  1. declare
  2.   cnt number := 1;
  3. begin
  4.   go_block('Blockname');
  5.   first_record;
  6.   while :system.last_record = 'FALSE'
  7.   loop
  8.   cnt := cnt + 1;
  9.   next_record;
  10.   end loop;
  11. message('There are ' || cnt || ' records in this block');
  12. end;

Thank You

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2014
Added on Dec 19 2013
29 comments
3,870 views