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
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.