Re: FORMS MESSAGES

On Thu, 02 Oct 1997 20:52:07 -0600, deepakrajan_at_hotmail.com wrote:

>Hi,
>
>In my form application, when saving a transaction,I have used the
>COMMIT_FORM procedure in a When_button_pressed trigger for the save
>button.When I run the form and press the save button,I get the message
>FRM-40401: No changes to save instead of the message FRM-40400:
>Transaction complete:1 record applied and saved.
>
>Is there a way to rectify this.At present,I am overriding this message
>with my own.
>

If you are getting the message 40401, then the form will not have carried out a commit, so no changes will actually have been saved.

The most common reason for getting this when you think you have changed things is that you have only changed items with the base=table property set to 'FALSE'. If you want FORMS to recognise that something has changed, and to carry out the save processing, then you should change a base-table item, which can be done just by assigning an item to itself (e.g. :blk_xxx:item_yyy := :blk_xxx.item_yyy; ).

If, on the other hand, you just want users to see the same message regardless of whether anything was actually saved or not ( presumably saying 0 records applied and saved), then messages can be intercepted and modified using an ON-MESSAGE trigger. RTFM for details.

--
The above posting represents the personal opinions of the author and
is not to be taken as official (or unofficial) policy or opinions of 
his employer.

Remove XSPAM from mail_id if replying via email.
Alex Heney, Living in the Global Village.