Home » Developer & Programmer » Forms » character parameter in default_where property
character parameter in default_where property [message #357051] Mon, 03 November 2008 12:56 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
set_block_property('vu_porders',default_where, v_condition );


In a set block property as shown above ,I want to pass 'PENDING' or 'RECIEVED' for v_condition variable at runtime.

How do I set v_condition := 'postatus = 'PENDING'

If I set v_condition := ||'|| PENDING ||'||' , it gives error.
How do I solve this problem



Re: character parameter in default_where property [message #357087 is a reply to message #357051] Mon, 03 November 2008 18:17 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

v_condition := ' postatus = ''PENDING'' '
Re: character parameter in default_where property [message #357544 is a reply to message #357051] Wed, 05 November 2008 17:33 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If it doesn't work the first time, display the built string via a 'msg;pause;' pair. This will show you what the system is going to be processing.

You can also use the 'two quotes' method. That is, 'postatus = 'PENDING' should be 'postatus = ''PENDING'''

David
Previous Topic: C# dll in Forms
Next Topic: client_text_io.put() utilityin oracle 10g forms with application server10g
Goto Forum:
  


Current Time: Wed Dec 07 07:02:03 CST 2016

Total time taken to generate the page: 0.08770 seconds