OraFAQ Forum: Forms » Unable to add condition with BETWEEN in PRE Query trigger in oracle forms

Home » Developer & Programmer » Forms » Unable to add condition with BETWEEN in PRE Query trigger in oracle forms (12.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to add condition with BETWEEN in PRE Query trigger in oracle forms [message #684191]

Mon, 19 April 2021 05:29

mohan.oracle42@gmail.com
Messages: 7
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

Report message to a moderator

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

Littlefoot
Messages: 21783
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');

Report message to a moderator

Previous Topic:	During FORM_TRIGGER_FAILURE disabled button getting enabled
Next Topic:	Oracle Forms 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 22:56:12 CDT 2023