date values in forms [message #78659] |
Fri, 08 March 2002 06:26 |
Stephen Agbodza
Messages: 4 Registered: February 2002
|
Junior Member |
|
|
Hi folks,
I am trying to query a block by programmatically setting the block default_where property. The where clause should be in the form
request_date between date1 and date2
where date1 and date2 are date values entered by the user.
I am finding it hard to build the correct string to pass to the set_block_property built-in.
Could somebody please help out?
Thanks in advance.
|
|
|
Re: date values in forms [message #78673 is a reply to message #78659] |
Sun, 10 March 2002 10:06 |
Robin
Messages: 73 Registered: October 2001
|
Member |
|
|
Hi,
Here i m giving example.
Lets say ur block is emp and columns which u want to pass to query are 'JOB' which is varchar2 column and 'MGR'
which is numeric columns..here i m giving code...check it.
Thanks
Robin
---------------------------------------------------
declare
v_default varchar2(100);
begin
v_default := 'mgr = '||:emp.mgr ||' AND job = '''||:emp.job||'''';
set_block_property('emp',default_where,v_default);
execute_query;
set_block_property('emp',default_where,''); --to set default where to blank
end;
|
|
|