Record count on Database Block
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.
And also i have written Get_block_property on function also
cnt number := 1;
while :system.last_record = 'FALSE'
cnt := cnt + 1;
message('There are ' || cnt || ' records in this block');