Re: Forms 4 - 'nothing to commit'

Mark Miller (mem8321_at_u.cc.utah.edu) wrote:
: In article <SMUENCH.94Jul5140514_at_doh.oracle.com>,
: Steven P. Muench <smuench_at_oracle.com> wrote:
: >ALL -- Information contained above is not correct.
: >
: > Forms 4.0 *does* go through normal Commit processing when
: > encountering the COMMIT or COMMIT_FORM instruction.
: >
 

: ** However, SQL*FORMS 3.0 does NOT do this. **
 

: -Mark.

SQL*Forms 3.0.16 does do a normal commit, even when the message line displayes 'Nothing to commit'. You can test this very easily, make a test form with 1 block and a non-basetable field. Write a key-nxtfld trigger with an insert statement in a dummy table. Hit [Nxtfld] and [Commit] Forms will display 'Nothing to commit', since there are no basetable fields, but if you open another session and check your dummy table with SQL*Plus, you will see that your data has been inserted.

Regards,

Olaf

--
Olaf vd Geest                              Oracle Corporation
ogeest_at_nl.oracle.com                       Rijnzathe 6
                                           De Meern

***         These opinions are mine and not those of my employer          ***