Home » Developer & Programmer » Forms » HOW TO ADD CLAUSE
HOW TO ADD CLAUSE [message #226239] Fri, 23 March 2007 01:17 Go to next message
u263066
Messages: 47
Registered: March 2007
Member
how to pass additional AND clause in
lv_Where := get_block_property('XXAP_PMT_REQUEST_HDR',default_where);
	 if :XXAP_PMT_REQUEST_HDR.CR_ID is not null then
	 lv_Where := 'CR_ID = '||:XXAP_PMT_REQUEST_HDR.cr_id;
--	 lv_and	  :	



MY FILTER WOULD BE
WHERE CR_ID = :XXAP_PMT_REQUEST_HDR.cr_id
AND VERSION_ID =|:XXAP_PMT_REQUEST_HDR.VERSION_ID;

ANY INPUT

[Updated on: Fri, 23 March 2007 01:19]

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226249 is a reply to message #226239] Fri, 23 March 2007 01:34 Go to previous messageGo to next message
u263066
Messages: 47
Registered: March 2007
Member
I TRIED WITH THIS ONE
DOES NOT WORK

	 lv_Where := get_block_property('XXAP_PMT_REQUEST_HDR',default_where);
	 if :XXAP_PMT_REQUEST_HDR.CR_ID is not null then
	-- lv_Where := 'CR_ID = '||:XXAP_PMT_REQUEST_HDR.cr_id;
	 lv_Where := 'CR_ID = '||:XXAP_PMT_REQUEST_HDR.cr_id || 'AND CR_INSTALLMENT ='||:XXAP_PMT_REQUEST_HDR.CR_INSTALLMENT	 lv_and	  :	
	 end if;
Re: HOW TO ADD CLAUSE [message #226282 is a reply to message #226249] Fri, 23 March 2007 02:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Print your lv_where. You'll notice you forgot a space before your AND
Re: HOW TO ADD CLAUSE [message #226301 is a reply to message #226282] Fri, 23 March 2007 03:59 Go to previous messageGo to next message
u263066
Messages: 47
Registered: March 2007
Member
lv_Where := 'CR_ID = '||:XXAP_PMT_REQUEST_HDR.cr_id || 'AND'|| CR_INSTALLMENT ='||:XXAP_PMT_REQUEST_HDR.CR_INSTALLMENT;

still not working
Re: HOW TO ADD CLAUSE [message #226314 is a reply to message #226301] Fri, 23 March 2007 04:31 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
'AND'|| CR_INSTALLMENT ='||:

Does not make sense. Check your quotes. Determine between fixed text and variables.
Re: HOW TO ADD CLAUSE [message #226324 is a reply to message #226314] Fri, 23 March 2007 04:46 Go to previous messageGo to next message
u263066
Messages: 47
Registered: March 2007
Member
i tried with
lv_Where := 'CR_ID = '||:XXAP_PMT_REQUEST_HDR.cr_id ||
'AND CR_INSTALLMENT ='||:XXAP_PMT_REQUEST_HDR.CR_INSTALLMENT;

still not filtering with CR_INSTALLMENT

any help Frank
Re: HOW TO ADD CLAUSE [message #226392 is a reply to message #226324] Fri, 23 March 2007 08:50 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Not filtering or giving errors??
You DID set the default_where back to lv_where, right??
Re: HOW TO ADD CLAUSE [message #226900 is a reply to message #226392] Mon, 26 March 2007 21:01 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Display the variable 'lv_Where' via a 'message' command after the 'get_block_property' command and after rebuilding it, I think you do NOT have a space before the 'AND' operand.

David
Previous Topic: How to find User (who is connected to AS) in 3-Tier Architecture
Next Topic: custom logon screen(new_form)
Goto Forum:
  


Current Time: Sun Dec 04 19:06:43 CST 2016

Total time taken to generate the page: 0.12856 seconds