1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Stuck in......

Discussion in 'Oracle Forms and Reports' started by salmankhalid, Jun 2, 2009.

  1. salmankhalid

    salmankhalid Forum Advisor

    Messages:
    116
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Lahore, Pakistan
    hi fellows i am stuck in a problem, i have three blocks on the form, one is master and the other two are detail blocks, there is a button on the form that clears all the data mens to say that

    CLEAR_FORM (NO_VALIDATE);

    the requirement is i have to clear both the detail blocks only whether the cursor is i nthe master block or in one of the detail blocks i know a code

    GO_BLOCK('MY_BLOCK_TO_CLEAR');
    CLEAR_BLOCK(No_Validate);

    but it only works for the block in the go block command

    Pls help me in resolving this issue (urgently required solution)
     
  2. srinath

    srinath Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    hello salman, this maybe late but why can't you use GO_BLOCK and CLEAR_BLOCK one after other like
    GO_BLOCK('B1');
    CLEAR_BLOCK(No_Validate);
    GO_BLOCK('B2');
    CLEAR_BLOCK(No_Validate);

    or maybe if you don't care about the first block you can do a CLEAR_FORM on B1
    "WHEN-NEW-BLOCK-INSTANCE".
     
    salmankhalid likes this.