OraFAQ Forum: Forms » how to default where condition

Home » Developer & Programmer » Forms » how to default where condition

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

how to default where condition [message #529618]

Wed, 02 November 2011 03:31

goparaju
Messages: 54
Registered: June 2011

Member

Hi Experts,

I am working on forms 6i. I have set where condition in pre-query of a trigger, my requirement is, in post-query, i want to delete the where condition. Could somebody help me how to do this.

pre-query:

set_block_property('HEADER_S',default_where,'STATUS IN (select meaning from XXSMCQSS_LOOKUP_VALUES where lookup_type=''CONCESSION STATUS CODES'' and primary_flag=''N'' )');

post_query: I want to delete this where condition, i just want make execute query normal by removing the where condition.

Kindly help me.

Report message to a moderator

Re: how to default where condition [message #529626 is a reply to message #529618]

Wed, 02 November 2011 04:03

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use ONETIME_WHERE instead.

Report message to a moderator

Re: how to default where condition [message #529628 is a reply to message #529626]

Wed, 02 November 2011 04:14

goparaju
Messages: 54
Registered: June 2011

Member

Hi,

Thanks for your reply.

set_block_property('HEADER_S',ONETIME_WHERE,'STATUS IN (select meaning from XXSMCQSS_LOOKUP_VALUES where lookup_type=''CONCESSION STATUS CODES'' and primary_flag=''N'' )');

Is this right way of using 'ONETIME_WHERE'.

Will this not consider the 'WHERE' condition from second time of execute query.

Kindly help.

Report message to a moderator

Re: how to default where condition [message #529629 is a reply to message #529628]

Wed, 02 November 2011 04:19

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What do you think, why is it called a onetime_where?

Report message to a moderator

Re: how to default where condition [message #529643 is a reply to message #529629]

Wed, 02 November 2011 04:50

goparaju
Messages: 54
Registered: June 2011

Member

Hi,

Thanks for your reply. I am working on forms 6i,it looks like 'ONETIME_WHERE' is not supporting in 6i. Could you tell me any other alternative.

Report message to a moderator

Re: how to default where condition [message #529651 is a reply to message #529643]

Wed, 02 November 2011 04:58

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try

set_block_property('HEADER_S', DEFAULT_WHERE, '')

Actually, perhaps you'd rather (prior to setting your own DEFAULT_WHERE clause) save the current DEFAULT_WHERE (using GET_BLOCK_PROPERTY) and then restore it in POST-QUERY trigger.

Report message to a moderator

Re: how to default where condition [message #529839 is a reply to message #529618]

Thu, 03 November 2011 05:31

softsolutionpk
Messages: 2
Registered: June 2011
Location: Karachi

Junior Member

set_block_property('DEMAND_MAST',
default_where,
'DEMAND_MAST.DAM_ID
= '''||(select dam_id
from test_demand
where id = :global.DAM_ID)||'''');

Dear Brother i hope that you get your object

Nasir

SoftSolution

Report message to a moderator