OraFAQ Forum: Forms » HOW TO ADD CLAUSE

Home » Developer & Programmer » Forms » HOW TO ADD CLAUSE

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

HOW TO ADD CLAUSE [message #226239]

Fri, 23 March 2007 01:17

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

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;

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226282 is a reply to message #226249]

Fri, 23 March 2007 02:53

Frank
Messages: 7901
Registered: March 2000

Senior Member

Print your lv_where. You'll notice you forgot a space before your AND

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226301 is a reply to message #226282]

Fri, 23 March 2007 03:59

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

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226314 is a reply to message #226301]

Fri, 23 March 2007 04:31

Frank
Messages: 7901
Registered: March 2000

Senior Member

'AND'|| CR_INSTALLMENT ='||:

Does not make sense. Check your quotes. Determine between fixed text and variables.

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226324 is a reply to message #226314]

Fri, 23 March 2007 04:46

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

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226392 is a reply to message #226324]

Fri, 23 March 2007 08:50

Frank
Messages: 7901
Registered: March 2000

Senior Member

Not filtering or giving errors??
You DID set the default_where back to lv_where, right??

Report message to a moderator

Re: HOW TO ADD CLAUSE [message #226900 is a reply to message #226392]

Mon, 26 March 2007 21:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 23:47:24 CST 2024