Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    26

    Unanswered: serach and redisplay form

    Hello,

    I have a form displaying the table scott.emp
    Then there exist two Text Items
    Hiredate_start and
    Hiredate_end
    where you enter the dates (format: dd.mm.yyyy)

    and another Button named Go_And_Search.

    If I press the Button Go_And_Search,
    I'd like to clear the form scott.emp
    and display in this form only the records
    with a hiredate between Hiredate_start
    and Hiredate_end.

    If the Go_And_Search Button is pressed a
    WHEN-BUTTON-PRESSED Trigger is started,
    containing the name of a procedure call_hiredate_search.

    In this Procedure I:

    GO_BLOCK('EMP');
    CLEAR_BLOCK(No_Validate);

    ...but then ..... I'm helpless

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    58
    then you need to do a set_block_property and change the default_where attribute for the block and then execute the form by execute_query. I am not sure of the exact syntax but you get the idea right?
    Last edited by da_coolestofall; 05-25-04 at 18:56.

  3. #3
    Join Date
    Aug 2003
    Posts
    26
    @da_coolestofall:
    Thanx for the fast reply, I got the idea, and in a first test it seems to work (with table dept).

    PROCEDURE call_search IS
    BEGIN
    GO_BLOCK('DEPT');
    CLEAR_BLOCK(No_Validate);

    SET_BLOCK_PROPERTY('DEPT', DEFAULT_WHERE, 'deptno BETWEEN :search.dept_start AND :search.dept_stop');
    EXECUTE_QUERY;

    NULL;
    END call_search;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •