RE: UPDATION IN A CALLED FORM - SQL*FORMS 3.0

From: <rzx2122_at_mcvax2.d48.lilly.com>
Date: 6 May 93 08:32:39 EST
Message-ID: <1993May6.083239.1_at_mcvax2.d48.lilly.com>

This is from the READ30.ME file that came with SQL*FORMS 3.0:

4. The default behavior of NEW_FORM and EXIT_FORM can now be overridden.

        EXIT_FORM and NEW_FORM each take an optional second parameter now that
        can be used to override the default behavior described in the
        documentation.  This parameter can take one of the following three
        values:

        TO_SAVEPOINT    This is the default value and means that upon exiting
                        the current form, any uncommitted changes in that form
                        will be rolled back.  SQL*Forms performs a rollback to
                        the current form's last savepoint upon leaving the
                        form.

        NO_ROLLBACK     This is the equivalent of earlier versions of SQL*Forms
                        3.0 where no rollback was issued by SQL*Forms upon
                        exit.  This means that you may leave the top level form
                        without performing a rollback, which means you
                        retaining the locks across a NEW_FORM.  These locks can
                        also occur when running SQL*Forms from a C program and
                        will still be in effect when you regain control back
                        from SQL*Forms.

        FULL_ROLLBACK   This is the same as TO_SAVEPOINT except that it rolls
                        back the entire transaction rather than just to the
                        current form's last savepoint.

The default behavior of called forms is now identical to SQL*Forms Version 2.3, which rolled back any changes not committed. The change is from prior version of SQL*Forms 3.0, which held locks across called forms for uncommitted changes.

---

What this means is that you must explicitly declare NO_ROLLBACK when exiting a form.

---

                                            chicago ,--------+  detroit
Tom Harleman                                        |        |
INOUG Committee Member                              |Indiana |
Paradigm Consulting, Inc.                 st.       | Oracle |
11080 Willowmere Drive                    louis     |  Users |
Indianapolis, IN  46280                             |   Group|
USA                                                 |        |
                                                    |      _,+cincinnati
INTERNET:   72072.2122_at_compuserve.com               /   _,'
Compuserve: 72072,2122                             /_,-'louisville
                                                   `


========================================================================

Received on Thu May 06 1993 - 15:32:39 CEST