This discussion is archived
3 Replies Latest reply: Mar 15, 2013 11:07 AM by Andreas Weiden RSS

FRM-40735: illegal restricted procedure COMMIT in POST-CHANGE trigger

875255 Newbie
Currently Being Moderated
I am using forms6i. I have three text fields FL1 ,*FL2* , FL3 in a form. Cursor passes from FL1 to FL2 and FL2 to FL3. I want when cursor transfers from FL1 to FL2 the form should be saved(commit). On FL1 i put COMMIT; in post-change.
But when I pressed Enter key on FL1 it gives following error message.

FRM-40735: illegal restricted procedure COMMIT in POST-CHANGE trigger

Can you help me doing this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points