6 Replies Latest reply: Nov 6, 2012 8:54 AM by 802719 RSS

    Using Set_block_property Default Where only one time

    Shahzaib Ismail Khan
      Hellow All

      I am using Set_block_property with Default_where but i need the where condition work only one time I use this query
      SET_BLOCK_PROPERTY('block2', DEFAULT_WHERE, 'name= ''' || :block180.name2 || '''');
      go_block('block2');
      EXECUTE_QUERY;
      Its work fine but he Block2 will Continue with Default_where

      For example when i execute all record its execute only the record where name=:block180.name2

      I need when i press button the trigger work and when i save my record or undo my record its will execute all record (not which name=:block180.name2


      I hope you guys understand


      Regards

      Shahzaib ismail