2 Replies Latest reply: Jan 7, 2013 9:03 AM by vansul RSS

    Button search

    982158
      Hi,
      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
          Askdineshsingh
          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
            vansul
            Yes he is right. you have to give him correct...