Re: SQLSQL*Forms 3.0 Pop-Up Window

In article <1992May7.141358.12734_at_rz.uni-karlsruhe.de> rz34_at_rz.uni-karlsruhe.de writes:
>I'm creating a SQL*Forms 3.0 form to be used for query purposes
>only. For this reason, I have created a pop-up window which appears
>when the user requests to exit the form. ( I want to do this because
>otherwise he/she is asked whether or not to commit, which, of course, is
>unnecessary since the form is for query only.)

If the form is asking you whether or not you want to quit you must be changing some field(s) in a block with a base table. If this is something you want to do then you can get around the "Do you want to commit" pop up by redefining your KEY-EXIT trigger to be:

BEGIN
    EXIT_FORM(NO_VALIDATE);
END; If you want to have a pop up asking whether they want to quit anyway you can try the following (keep in mind, I haven't tried this but it might work):

BEGIN
    :BLOCK.field = invalid data;
    EXIT_FORM(NO_COMMIT);
END; The first step sets a field in a block to value that will cause an on-validate-field trigger to fail. The EXIT_FORM(ON_COMMIT) will first validate the data in the form. If everything is valid then it will exit without commiting. If something is invalid (which there will be in this case) a pop up window will come up asking the user "Do you want to quit?".

Good luck,
Rich

>
>On the pop-up window I want to ask the user whether or not he/she
>really wants to exit. So the answer must, I think, go in a variable.
>If the answer is yes, the form will be exited, otherwise form goes
>back to first block.
>
>There is probably a very simple solution to this, or even an existing
>packaged procedure... but being new at this, I'm a bit baffled.
>
>Can anyone help me?
>
>Please send replies via E-Mail.
>
>Thanks in advance!
>Karen Schillinger
Received on Fri May 08 1992 - 00:02:10 CEST