Passing date values in Oracle Forms

Hi folks,
I am trying to query a block by programmatically building the query string in PL/SQL and setting the block default_where property to the built string.

the query string that is generated depends on entries in 3 boxes on the form. A box for a warehouse code and the other two boxes for the start and end dates. If the warehouse code box is not null and the 2 date boxes are null, then
the query string is as follows

   v_warehouse := :queryblock.warehouse;    v_where := 'requested_from='||''''||v_warehouse||'''';    set_block_property('stock_transfer',default_where,v_where);    execute_query;

This works fine.
However if i want to restrict the returned data to a period defined by a start and end date, then the query string should be in the form

   v_where := 'requested_from='||''''||v_warehouse||'''' and 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. Received on Sat Mar 16 2002 - 07:45:06 CST