| dynamic where condition using set_block_property [message #530233] |
Mon, 07 November 2011 05:42  |
 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
