| character parameter in default_where property [message #357051] |
Mon, 03 November 2008 12:56  |
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 #357544 is a reply to message #357051] |
Wed, 05 November 2008 17:33  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
