Re: Forms5 help

Well, use something like:

declare
  blk_id_01 Block;
BEGIN
  blk_id_01:= Find_Block('emp');

    Set_Block_Property(blk_id_01,default_where,'hiredate >= :first_text_item

                   AND hiredate <= :second_text_item ');

It will work like that if your user enters a DD-MON-YY date. Otherwise you will have to control what they enter and deal with the format by converting the character field using to_date, then to_char with format specified. Is that as clear as mud? ;-)

rq

wozi wrote:

> using scott.emp table as example.
>
> I created a multi-record block and placed it on canvass. I also place
> 2 non-base text items and a button on the canvass.
>
> The button basically performs execute_query and that workds fine since all
> records in the emp table are displayed. However, when I enter dates in the
> 2 text items, I want to set_block_property('emp', default_where, ???) such
> that
> the hiredate in the table would show those records that are between the date
> ranges enetred in the canvass.
>
> I need help constructing the default_where statement. Thanks very much.
> Reply also to tyc77_at_hotmail.com
Received on Thu Dec 02 1999 - 23:02:29 CET