dynamic where condition using set_block_property [message #530233] |
Mon, 07 November 2011 05:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9fc2c55773e60a8cef395fa8cb47a31f?s=64&d=mm&r=g) |
goparaju
Messages: 54 Registered: June 2011
|
Member |
|
|
Hi Experts,
I am working on Forms 6i. I have data block A on table EMP.
Datablock A: Empno, Ename, Hiredate
I have FIND Screen: EMPNO, HIREDATE_FM,HIREDATE_TO and FIND Button.
I will search the records through FIND Screen.
I want to set the where condition of block A in pre-query trigger.
set_block_property('BLOCKA',default_where,'HIRE_DATE BETWEEN FIND.HIREDATE_FM and FIND.HIREDATE_TO');
Note: FIND in above is FIND Screen block.
It's not fetching any records, i doubt that there is syntax error in above statement.
Could somebody help me with that.
|
|
|
|