2 Replies Latest reply on Jan 7, 2013 3:03 PM by vansul

    Button search

      In my interface I have a table that contains all the recorded ,and I have a "search" button ...
      I want when I press this button, the result will be displayed in the table.
      So what should i do ?

      Edited by: 979155 on 6 janv. 2013 13:09

      Edited by: 979155 on 7 janv. 2013 02:35
        • 1. Re: Button search
          if you have created the block as database block of table type then you can write the search condition in Where clause of Database block by using the concatenation of all fields in folloiwing manner
          --write in where clause of datablock
          upper(column1||column2||column3) like '%'||:search_field||'%'
          in runtime it will execute in following manner...
          SELECT column1, column2 ,column3 from table
          where upper(column1||column2||column3) like '%'||:search_field||'%'

          then EXECUTE QUERY ON BLOCK will filter the records on the base of you query results.
          Hope this will help you out..
          Please mark this reply as correct/helpful.
          • 2. Re: Button search
            Yes he is right. you have to give him correct...