Adsense Ad

Monday 29 June 2020

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);

1 comment:

Ajith said...

Hi,
Interesting article! Thank you for sharing them! keep sharing! much helpful for more person .if want GST Registration Consultants in bangalore Tax Return Filing in bangalore click on it