Do you want to save changes you have made

Do you want to save changes you have made

In Oracle Forms After querying records and exiting from form you often receive message "Do you want to save changes you have made".

Reason is very simple you are updating the fields in most probably post-query or other trigger. when any field changes, the changes ask to save it.

Solution is also very simple:

Use below line at the end of all post query triggers:
set_record_property(:system.trigger_record,:system.trigger_block,status,query_status);

OR

Use: set_item_property(<block_name.item_name>, item_is_valid, property_true);

For every item being updated.

Regards,

Zahid Rahim

Tags: Oracle Forms, Do you want to save changes you have made, Post-Query