EXPERT RESPONSE
The error message is correct. When you perform DML on a field that is
not on your form, this is considered a database change, not a form
change. Since nothing on the form or on the block has changed, there is
nothing to save. You do need a commit command to save your database
change. I suggest the following sequences of commands:
:System.Message_Level := '20';
commit;
:System.Message_Level := '0';
By assigning '20' to :system.message_level, only the most severe error
message will be displayed. All other error messages will be suppressed,
including the "no changes to save" error message. When assigning '0' to
:system.message_level, this allows all error messages to be displayed.
|
