SQL$Forms Commit Procedure
From: <ditommm_at_aa.wl.com>
Date: Tue, 01 Feb 94 13:45:13 EST
Message-ID: <2im89h$232_at_reeve.research.aa.wl.com>
Date: Tue, 01 Feb 94 13:45:13 EST
Message-ID: <2im89h$232_at_reeve.research.aa.wl.com>
I have a form (SQL*Forms 3.0 on VAX/VMS) which makes changes to tables directly through PL/SQL procedures that contain INSERT, UPDATE and DELETE statements. Sometimes these changes are the only changes made during the current session. If the user COMMIT's the error message '40401 - no changes to commit' appears. Is there any way to let SQL*FORMS know that thre really is something to commit - perhaps by changing FORM_STATUS directly? If I do the COMMIT in a user exit then the records are locked until the user exits SQL*Forms, since I cannot RELEASE without disconnecting from the database.
Thanks for any assistance.
Matteo diTommaso
ditommm_at_aa.wl.com
Received on Tue Feb 01 1994 - 19:45:13 CET