I have created a page showing data in two regions. this page is a dialog page showing data from previous page/link
region 1 is form
region 2 is interactive grid using SQL > when i use where clause it does not show data unless i click GO button. i tried to put fixed value in where clause also but i didn't work
try 1: select * from emp where deptid = 10 (no data show)
try 2: select * from emp where deptid = ":p13_deptid" (no data show)
data showed if i click GO button inside the grid
i tried DYNAMIC ACTION to refresh grid .. when p13_deptid change << nothing happend
try 3: select * from emp (all data showed)
why interactive grid not showing data when i put where clause by default and how can i refersh without clicking GO button
thanks in advance