This discussion is archived
2 Replies Latest reply: Jan 7, 2013 7:03 AM by vansul RSS

Button search

982158 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Yes he is right. you have to give him correct...


  • Correct Answers - 10 points
  • Helpful Answers - 5 points