3 Replies Latest reply on Nov 29, 2013 11:03 AM by juliojgs

    disable unused records in multi-record block

    smon

      Forms [64 Bit] Version 11.1.2.1.0

       

      I have a multi-record block based on a table. The block properties state it can show a max of 5 records on screen, the only item in the block is an image placeholder, which obviously gets populated with the images on execute_query.

       

      My requirement is if the query only returns 3 images for instance, I want to disable/hide the remaining 2 placeholders.

       

      Is there a trigger that fires just once after the sql transaction has finished and all records are fetched? If so I could code a loop through the block items and disable any that aren't populated. I couldn't find the correct trigger though. Post-Query fires after each record, rather than at the end of the entire fetch.

       

      If that's not the way to do it, has anyone got any other suggestions?

       

      thanks in advance.