OraFAQ Forum: Forms » default_where question (merged)

Home » Developer & Programmer » Forms » default_where question (merged)

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

default_where question (merged) [message #404905]

Mon, 25 May 2009 06:58

vallis a rosa
Messages: 4
Registered: April 2009

Junior Member

Hello everyone.

I have a question about a default_where. I've written the following plsql code:

      elsif :x.lbnodig = 'TNM' then
         set_block_property('b',DEFAULT_WHERE, 'where vwtaak_pm.detakty = ''TK'' and vwtaak_pm.denodur != 0 or vwtaak_pm.detakty != ''TK''' );
         navigate_to_block('b');
         execute_query;
      end if;

but when i use it, it shows all the records from the database and not the records only from the masterblock.

The code triggers when a listbox changed.
The other values from the listbox are working good.

Can anyone help me solve this question..

Thanks in advance..

Jr

Report message to a moderator

Re: default_where question (merged) [message #404912 is a reply to message #404905]

Mon, 25 May 2009 07:26

nagu_bhat
Messages: 10
Registered: May 2009

Junior Member

Hi

Please change the code as per this

elsif Mad

.lbnodig = 'TNM' then
set_block_property('b',DEFAULT_WHERE, 'where (vwtaak_pm.detakty = ''TK'' and vwtaak_pm.denodur != 0) or vwtaak_pm.detakty != ''TK''' );
navigate_to_block('b');
execute_query;
end if;

Regards
Nagaraj

Report message to a moderator

Re: default_where question (merged) [message #404913 is a reply to message #404912]

Mon, 25 May 2009 07:29

vallis a rosa
Messages: 4
Registered: April 2009

Junior Member

thanks for your reaction, but it gave the same result as my code.

greetz

Report message to a moderator

Re: default_where question (merged) [message #404916 is a reply to message #404905]

Mon, 25 May 2009 07:44

vallis a rosa
Messages: 4
Registered: April 2009

Junior Member

i've solved the problem myself.. Razz

      elsif :x.lbnodig = 'TNM' then
         set_block_property('b',DEFAULT_WHERE, '((vwtaak_pm.detakty = ''TK'' and vwtaak_pm.denodur != 0) or (vwtaak_pm.detakty != ''TK''))' );
         navigate_to_block('b');
         execute_query;
      end if;

greetz

Report message to a moderator

Previous Topic:	How to list the Mail address from forms6i?
Next Topic:	internet explorer is getting closed when trying to run 10g forms(merged2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 03:48:51 CST 2025