Forms 4.5 & stored procedures - problems with COMMIT

From: Alex Savitsky <asavicki_at_sprint.ca>
Date: Tue, 8 Jun 1999 16:23:02 -0400
Message-ID: <v_e73.45595$r_1.24074331@newscontent-02.sprint.ca>

Hi all!

Here is the problem I'm stuck with: I have a Forms application that calls several stored procedures, which actually do all work, i.e. block is marked as non-base-table and no items are bound to database columns. However, it seems I cannot commit data! As long as I am in application, changes I made are there, but when I exit changes are gone. COMMIT says that 'No changes to save'; so does COMMIT_FORM. If I use EXIT_FORM(DO_COMMIT) instead of simply EXIT_FORM, it doesnt work either. I really would like to avoid putting COMMIT inside procedures. Is there any other way of doing it?

TIA Alex Received on Tue Jun 08 1999 - 15:23:02 CDT