1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Record count message on database Block in Forms

Discussion in 'Oracle Forms and Reports' started by mist, Dec 19, 2013.

  1. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    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;

    But not working me.

    Thank you