Home » Developer & Programmer » Forms » default_where question (merged)
default_where question (merged) [message #404905] Mon, 25 May 2009 06:58 Go to next message
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

Re: default_where question (merged) [message #404912 is a reply to message #404905] Mon, 25 May 2009 07:26 Go to previous messageGo to next message
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
Re: default_where question (merged) [message #404913 is a reply to message #404912] Mon, 25 May 2009 07:29 Go to previous messageGo to next message
vallis a rosa
Messages: 4
Registered: April 2009
Junior Member
thanks for your reaction, but it gave the same result as my code.

greetz
Re: default_where question (merged) [message #404916 is a reply to message #404905] Mon, 25 May 2009 07:44 Go to previous message
vallis a rosa
Messages: 4
Registered: April 2009
Junior Member
i've solved the problem myself.. Razz 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
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:
  


Current Time: Tue Dec 06 10:32:42 CST 2016

Total time taken to generate the page: 0.16213 seconds