Home » Developer & Programmer » Forms » Unable to add condition with BETWEEN in PRE Query trigger in oracle forms (12.2)
Unable to add condition with BETWEEN in PRE Query trigger in oracle forms [message #684191] Mon, 19 April 2021 05:29 Go to next message
mohan.oracle42@gmail.com
Messages: 1
Registered: April 2021
Junior Member
IN oracle standard form where clause written in pre_query trigger , It already customized now need to add one more date rage condition.

PREQ_QUERY Trigger:

:BLOCK_NAME.job := :CONTROL_QF.job;
:BLOCK_NAME.deptno := :CONTROL_QF.deptno;

Trying to add below condition but not sure how to add , Please suggest.

:BLOCK_NAME.Create_Date between :CONTROL_QF.DATE_FROM and CONTROL_QF.Date_to

it is allowing only one value like below.

:BLOCK_NAME.Create_Date := :CONTROL_QF.DATE_FROM
Re: Unable to add condition with BETWEEN in PRE Query trigger in oracle forms [message #684202 is a reply to message #684191] Wed, 21 April 2021 14:53 Go to previous message
Littlefoot
Messages: 21670
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option is to use SET_BLOCK_PROPERTY built-in, its ONETIME_WHERE property, and then set yet another condition. See documentation for more info.

set_block_property('block_name', onetime_where, 'create_date between :control_qf.date_from and :control_qf.date_to');
Previous Topic: During FORM_TRIGGER_FAILURE disabled button getting enabled
Next Topic: Oracle Forms 12c
Goto Forum:
  


Current Time: Sat May 08 07:32:44 CDT 2021